/*-----------Permision Part-----------------------*/
DECLARE @numGroupID int
DECLARE i CURSOR FOR
select numGroupID from tblPermissionsGroupsList
OPEN i
FETCH NEXT FROM i INTO @numGroupID
WHILE @@FETCH_STATUS = 0
BEGIN
DELETE FROM tblManagementFiles2GroupsList WHERE numFileID=@numFileID and numGroupID=@numGroupID
INSERT INTO tblManagementFiles2GroupsList (numFileID , numGroupID , txtAction ) VALUES(@numFileID, @numGroupID,'View')
INSERT INTO tblManagementFiles2GroupsList (numFileID , numGroupID , txtAction ) VALUES(@numFileID, @numGroupID,'Update')
INSERT INTO tblManagementFiles2GroupsList (numFileID , numGroupID , txtAction ) VALUES(@numFileID, @numGroupID,'Add')
FETCH NEXT FROM i INTO @numGroupID
END
CLOSE i
DEALLOCATE i
/*------------------------------------------------*/