Use common


USE T23E001

INSERT INTO T23E001.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, 0, 'Dr', 0, 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 NOT IN (SELECT AccCode FROM T23E001.DBO.ACCOUNT_MASTER)