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)