⬅ Back MISSING GREY ITEM MASTE FROM LASTE YEAR.txt
use T23S001

insert into GREY_ITEM_MASTER select * from T22S001.dbo.GREY_ITEM_MASTER where ItemName collate database_default not in (select ItemName from GREY_ITEM_MASTER)


use COMMON

SELECT * FROM GREY_ITEM_MASTER
insert into common.dbo.GREY_ITEM_MASTER
SELECT     ItemName, ItemRatePerPcs, ItemRatePerMts, HSNCode, GSTPerc, DescGST, EntType
FROM         T22S001.dbo.GREY_ITEM_MASTER 
where ItemName collate database_default not in (select ItemName from GREY_ITEM_MASTER)