⬅ Back Missing UPDATE Account Master.sql
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, JobType=T1.JobType, DiscPerc=T1.DiscPerc, RDPerPcs=T1.RDPerPcs, RDPerMts=T1.RDPerMts, InsPolicyNo=T1.InsPolicyNo, Dhara=T1.Dhara, DharaDays=T1.DharaDays, TransName=T1.TransName, AccAdd21=T1.AccAdd21, AccAdd22=T1.AccAdd22, AccAdd23=T1.AccAdd23, AccCityName2=T1.AccCityName2, AccCityPin2=T1.AccCityPin2,  
BlackListed=T1.BlackListed, BankDetail=T1.BankDetail, ExcessRate=T1.ExcessRate, SeriesName=T1.SeriesName, CommPerc=T1.CommPerc, TDSLimit=T1.TDSLimit, BankName=T1.BankName, AccountNo=T1.AccountNo, IFSCCode=T1.IFSCCode, Branch=T1.Branch, LessDays=T1.LessDays, PackPerPcs=T1.PackPerPcs, BankCommPerc=T1.BankCommPerc, BankCommLessPerc=T1.BankCommLessPerc, PackPerMts=T1.PackPerMts, PostageCharge=T1.PostageCharge, Taxable=T1.Taxable, GSTIN=T1.GSTIN, CompScheme=T1.CompScheme, GSTCategory=T1.GSTCategory, ECommGSTIN=T1.ECommGSTIN, GSTRegDate=T1.GSTRegDate, AccManager=T1.AccManager, CityDistanceKM=T1.CityDistanceKM, TCSCollectFrom=T1.TCSCollectFrom  
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, JobType, DiscPerc, RDPerPcs, RDPerMts, InsPolicyNo, Dhara, DharaDays, TransName, AccAdd21, AccAdd22, AccAdd23, AccCityName2, AccCityPin2, BlackListed, BankDetail, ExcessRate, SeriesName, CommPerc, TDSLimit, BankName, AccountNo, IFSCCode, Branch, LessDays, PackPerPcs, BankCommPerc, BankCommLessPerc, PackPerMts, PostageCharge, Taxable, GSTIN, CompScheme, GSTCategory, ECommGSTIN, GSTRegDate, AccManager, CityDistanceKM, SMAccCode, TCSApplicable, TCSCollectFrom FROM COMMON.dbo.ACCOUNT_MASTER WHERE AccCode = ' & UpdCode & ') AS T1 WHERE T1.AccCd COLLATE DATABASE_DEFAULT= AccCode