USE COMMON


-----RUN IN ALLFIRM


update AGENT_MASTER set AgentName=T1.AgentName, AgentAdd1=T1.AgentAdd1, AgentAdd2=T1.AgentAdd2, AgentAdd3=T1.AgentAdd3, AgentCityName=T1.AgentCityName, AgentCityPin=T1.AgentCityPin, AgentPhone=T1.AgentPhone, AgentMobile=T1.AgentMobile, AgentFax=T1.AgentFax, AgentEmail=T1.AgentEmail, AgentResident=T1.AgentResident, AgentPANNo=T1.AgentPANNo, AgentContPerson=T1.AgentContPerson, AccType=T1.AccType, BlackListed=T1.BlackListed, GSTIN=T1.GSTIN, CompScheme=T1.CompScheme, GSTRegDate=T1.GSTRegDate, MstType =T1.MstType FROM (
SELECT     AgentCode AS F1, AgentName, AgentAdd1, AgentAdd2, AgentAdd3, AgentCityName, AgentCityPin, AgentPhone, AgentMobile, AgentFax, AgentEmail, AgentResident, AgentPANNo, AgentContPerson, AccType, 
                      BlackListed, GSTIN, CompScheme, GSTRegDate, MstType FROM         T25V003.dbo.AGENT_MASTER
) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = AgentCode