use commone
Insert Into ACCOUNT_MASTER Values('TDSRA/C','TDS A/C','TDS PAYABLE','-DIRECT','-NONE','','','','',0,'','','','','','','','','','','',0,0,'','','NO','','','','',0,0,'N','','NO','TAXABLE SUPPLY','','',0,'','0','','','')
Insert Into ACCOUNT_MASTER Values('TDSPA/C','TDS RECEIVABLE A/C','TDS RECEIVABLE','-DIRECT','-NONE','','','','',0,'','','','','','','','','','','',0,0,'','','NO','','','','',0,0,'N','','NO','TAXABLE SUPPLY','','',0,'','0','','','')

INSERT INTO E26K001.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, DiscPerc, RDPerPcs, RDPerMts, 
                      JobType, InsPolicyNo, Taxable, GSTIN, CompScheme, GSTCategory, GSTRegDate, AccManager, CityDistanceKM, TransName, BlackListed, UdyamRegNumber, EnterpriseType, 
                      EnterpriseActivity
FROM         COMMONE.dbo.ACCOUNT_MASTER where AccCode like '%TDS%' AND AccCode NOT IN (SELECT AccCode FROM E26K001.DBO.ACCOUNT_MASTER)