use T25J001

UPDATE ACCOUNT_MASTER SET AccName=T1.AccName, AccAgentCode=T1.AccAgentCode, AccGroupCode=T1.AccGroupCode, AccAdd1=T1.AccAdd1, AccAdd2=T1.AccAdd2, AccAdd3=T1.AccAdd3, AccCityName=T1.AccCityName, AccCityPin=T1.AccCityPin, AccPhone=T1.AccPhone, AccMobile=T1.AccMobile, AccFax=T1.AccFax, AccEmail=T1.AccEmail, AccResident=T1.AccResident, AccGSTNo=T1.AccGSTNo, AccCSTNo=T1.AccCSTNo, AccPANNo=T1.AccPANNo, AccVATNo=T1.AccVATNo, AccContPerson=T1.AccContPerson, AccRef=T1.AccRef, AccCrLimit=T1.AccCrLimit, AccCrDays=T1.AccCrDays, AccTANNo=T1.AccTANNo, AccKSTNo=T1.AccKSTNo, TDSYesNo=T1.TDSYesNo, TDSAccount=T1.TDSAccount, DiscPerc=T1.DiscPerc, RDPerPcs=T1.RDPerPcs, RDPerMts=T1.RDPerMts, JobType=T1.JobType, InsPolicyNo=T1.InsPolicyNo, Taxable=T1.Taxable, GSTIN=T1.GSTIN, CompScheme=T1.CompScheme, GSTCategory=T1.GSTCategory, GSTRegDate=T1.GSTRegDate, AccManager=T1.AccManager, CityDistanceKM=T1.CityDistanceKM, TransName=T1.TransName, BlackListed=T1.BlackListed 
,UdyamRegNumber=T1.UdyamRegNumber,EnterpriseType=T1.EnterpriseType,EnterpriseActivity=T1.EnterpriseActivity 
FROM (SELECT AccCode As AccCd, AccName, AccAgentCode, AccGroupCode, AccAdd1, AccAdd2, AccAdd3, AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, AccResident, AccGSTNo, AccCSTNo, AccPANNo, AccVATNo, AccContPerson, AccRef, AccCrLimit, AccCrDays, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, DiscPerc, RDPerPcs, RDPerMts, JobType, InsPolicyNo, Taxable, GSTIN, CompScheme, GSTCategory, GSTRegDate, AccManager, CityDistanceKM, TransName, BlackListed, UdyamRegNumber, EnterpriseType, EnterpriseActivity 
FROM T24J001.dbo.ACCOUNT_MASTER) AS T1 WHERE T1.AccCd COLLATE DATABASE_DEFAULT= AccCode