SQL Script to assign all items to all sites in Microsoft GP

Assign All Items to ALL Sites
 -------------------------------------------------------- -- Assign All Items to ALL Sites -- Code by Venugopal G A -- Below script will assign all the available inventory item -- to all available sites if they are not assigned already. -- mail me for any queries venuasg@gmail.com -------------------------------------------------------- DECLARE @ITEM varchar(100) DECLARE @LOCATION varchar(100) DECLARE @ITEMAlreadyExist int DECLARE ITEMMASTER CURSOR FOR SELECT ITEMNMBR FROM IV00101 OPEN ITEMMASTER FETCH NEXT FROM ITEMMASTER INTO @ITEM WHILE (@@fetch_status <> -1) BEGIN DECLARE SITE CURSOR FOR SELECT LOCNCODE FROM IV40700 OPEN SITE FETCH NEXT FROM SITE INTO @LOCATION WHILE (@@fetch_status <> -1) BEGIN SELECT @ITEMAlreadyExist = isnull(count(*), 0) FROM IV00102 where ITEMNMBR = @ITEM and LOCNCODE = @LOCATION if @ITEMAlreadyExist = 0 BEGIN INSERT INTO IV00102 VALUES(@ITEM,@LOCATION,'',2,'',0,0,0,0 ,'01/01/1900','','01/01/1900',0,0,0,0,0,0,0,0,0,0,0,0 ,'01/01/1900','01/01/1900','01/01/1900','01/01/1900',0,'' ,'','',1,0,0,1,0,0,1,2,0,0,0,0,0,0,0,1,0,0,0,3,0,0,0,'' ,'','','','','','','',1,1,'',1,1,0,1,1,1,0,0,0,0,0) END FETCH NEXT FROM SITE INTO @LOCATION END DEALLOCATE SITE FETCH NEXT FROM ITEMMASTER INTO @ITEM END DEALLOCATE ITEMMASTER