INSERT INTO ComponentTable (ComponentName) 
VALUES 
('ProformaInvoice'), 
('JobOrder'), 
('VehicleType'),
('Repair'),
('Technician'),
('Replacement'),
('Project');



DECLARE @GroupIds TABLE (GroupId INT)
INSERT INTO @GroupIds VALUES (1),(3),(4)

DECLARE @ComponentId INT = 217

WHILE @ComponentId <= 223                 
BEGIN
    INSERT INTO [GroupPermissions] ([GroupId], [ComponentId], [CanView], [CanAdd], [CanEdit], [CanDelete])
    SELECT GroupId, @ComponentId, 0, 0, 0, 0
    FROM @GroupIds
    
    SET @ComponentId = @ComponentId + 1
END