--------------RUN IN ALL FIRM

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)

INSERT INTO COMMON.DBO.SCREEN_ITEM_MASTER SELECT ItemName, ItemRatePerPcs, ItemRatePerMts, ItemGrp, ItemImagePath, ItemOn, ItemCut, FabCost, JobCost, TotCost, CatalogName, Target, ItemImagePath2, ItemImagePath3, ItemImagePath4, ItemImagePath5, ScreenPcs, PurRatePerPcs, PurRatePerMts, ProfitPerc, Size, HSNCode, GSTPerc FROM SCREEN_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM COMMON.DBO.SCREEN_ITEM_MASTER)

INSERT INTO COMMON.DBO.GREY_ITEM_MASTER SELECT ItemName, ItemRatePerPcs, ItemRatePerMts, HSNCode, GSTPerc, DescGST, EntType FROM GREY_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM COMMON.DBO.GREY_ITEM_MASTER)

INSERT INTO GENERAL_ITEM_MASTER SELECT * FROM COMMON.DBO.GENERAL_ITEM_MASTER WHERE GeneralItemName NOT IN (SELECT GeneralItemName FROM GENERAL_ITEM_MASTER)