use T25L001 INSERT INTO T25L001.dbo.GREY_ITEM_MASTER SELECT * FROM T24L001.dbo.GREY_ITEM_MASTER WHERE ItemName not in (select itemname from T25L001.dbo.GREY_ITEM_MASTER) INSERT INTO T25L001.dbo.FINISHED_ITEM_MASTER SELECT * FROM T24L001.dbo.FINISHED_ITEM_MASTER WHERE ItemName not in (select itemname from T25L001.dbo.FINISHED_ITEM_MASTER) INSERT INTO T25L001.dbo.SCREEN_ITEM_MASTER SELECT * FROM T24L001.dbo.SCREEN_ITEM_MASTER WHERE ItemName not in (select itemname from T25L001.dbo.SCREEN_ITEM_MASTER) INSERT INTO T25L001.dbo.SUB_SCREEN_ITEM_MASTER SELECT * FROM T24L001.dbo.SUB_SCREEN_ITEM_MASTER WHERE ItemName not in (select itemname from T25L001.dbo.SUB_SCREEN_ITEM_MASTER) INSERT INTO T25L001.dbo.GENERAL_ITEM_MASTER SELECT * FROM T24s001.DBO.GENERAL_ITEM_MASTER WHERE GeneralItemName NOT IN (SELECT GeneralItemName FROM GENERAL_ITEM_MASTER)