USE COMMON

SELECT * FROM ACCOUNT_MASTER WHERE ACCNAME='RAM RATAN PAWAN KUMAR.'

--RUN IN CURRENT FIRM

USE T25M001

USE COMMON



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 T24M001.dbo.ACCOUNT_MASTER) AS T1 WHERE T1.AccCd COLLATE DATABASE_DEFAULT= AccCode