use T19B001

INSERT INTO AGENT_MASTER SELECT AgentCode, AgentName, AgentAdd1, AgentAdd2, AgentAdd3, AgentCityName, AgentCityPin, AgentPhone, AgentMobile, AgentFax, AgentEmail, AgentResident, AgentPANNo, AgentContPerson, AccType, BlackListed, GSTIN, CompScheme, GSTRegDate, MstType FROM COMMON.dbo.AGENT_MASTER WHERE (AgentCode COLLATE database_default NOT IN (SELECT AgentCode FROM AGENT_MASTER))