INSERT INTO AGENT_MASTER SELECT * 
FROM T24S001.DBO.AGENT_MASTER WHERE AGENTCODE NOT IN (SELECT AgentCode FROM AGENT_MASTER)

INSERT INTO GROUP_MASTER SELECT * 
FROM T24S001.DBO.GROUP_MASTER WHERE GRPCODE NOT IN (SELECT GRPCode FROM GROUP_MASTER)

INSERT INTO COMMON.DBO.ACCOUNT_MASTER
SELECT     AccCode, AccName, AccType, 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         ACCOUNT_MASTER WHERE AccCode NOT IN (SELECT AccCode FROM COMMON.DBO.ACCOUNT_MASTER)

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