INSERT INTO CITY_MASTER SELECT * FROM COMMON.DBO.CITY_MASTER WHERE CITYNAME COLLATE DATABASE_DEFAULT NOT IN (SELECT CITYNAME FROM CITY_MASTER)