USE T24G001

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, UdyamRegNumber, EnterpriseType, EnterpriseActivity
FROM         ACCOUNT_MASTER WHERE ACCCODE COLLATE DATABASE_DEFAULT NOT IN (SELECT ACCCODE FROM COMMON.DBO.ACCOUNT_MASTER)