⬅ Back Ahmed Tex 18-11-2021.txt
use T21A001

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