DECLARE @GroupIds TABLE (GroupId INT) INSERT INTO @GroupIds VALUES (1), (3) DECLARE @ComponentId INT = 128 WHILE @ComponentId <= 138 BEGIN INSERT INTO [GroupPermissions] ([GroupId], [ComponentId], [CanView], [CanAdd], [CanEdit], [CanDelete]) SELECT GroupId, @ComponentId, 0, 0, 0, 0 FROM @GroupIds SET @ComponentId = @ComponentId + 1 END