⬅ Back Missing Finished Item Master.sql
use t23s001

insert into common.dbo.finished_item_master
SELECT     ItemName, ItemQuality, ItemCategories, ItemRatePerPcs, ItemRatePerMts, ItemCut, ItemTopName, ItemTopMts, ItemMiddleName, ItemMiddleMts, ItemBottomName, ItemBottomMts, ItemOtherName, 
                      ItemOtherMts, ItemCutPcsMtr, ItemMtsPerKG, ItemGrp, ItemImagePath, FoldPerc, ItemImagePath2, ItemImagePath3, ItemImagePath4, ItemImagePath5, PurRatePerPcs, PurRatePerMts, HSNCode, 
                      GSTPerc, DescGST, ItemPer
FROM         FINISHED_ITEM_MASTER where itemname not in (select itemname from common.dbo.finished_item_master)