⬅ Back UPDATE ACCOUNT MASTER ALL DETAIL INTO BACK YEAR TO CURRENT YEAR.sql
use t27t001



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,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, 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, UdyamRegNumber, EnterpriseType, EnterpriseActivity 
FROM t26t001.dbo.ACCOUNT_MASTER) AS T1 WHERE T1.AccCd COLLATE DATABASE_DEFAULT= AccCode




https://files.tamannasolutions.net/?path=&view=UPDATE ACCOUNT MASTER ALL DETAIL INTO BACK YEAR TO CURRENT YEAR.sql