use t23m00


insert into T25R001.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, UdyamRegNumber, EnterpriseType, EnterpriseActivity
FROM         common.dbo.ACCOUNT_MASTER where acccode collate database_default not in (select acccode from T25R001.dbo.account_master)





INSERT DATABASE MASTER IN COMMON

USE T26V001



SELECT * FROM COMMON.dbo.account_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, UdyamRegNumber, EnterpriseType, EnterpriseActivity
FROM         T26V001.dbo.ACCOUNT_MASTER where acccode collate database_default not in (select acccode from COMMON.dbo.account_master)


DROP TABLE ACCOUNT_MASTER
Create Table ACCOUNT_MASTER (AccCode Varchar(7) Primary Key,AccName Varchar(50),AccType Varchar(35),AccAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),AccGroupCode Varchar(7) Foreign Key References GROUP_MASTER(GrpCode),AccAdd1 Varchar(100), AccAdd2 Varchar(100),AccAdd3 Varchar(100),AccCityName Varchar(35),AccCityPin bigint,AccPhone Varchar(35),AccMobile Varchar(35),AccFax Varchar(35),AccEmail Varchar(50),AccResident Varchar(35),AccGSTNo Varchar(35),AccCSTNo Varchar(35),AccPANNo Varchar(35),AccVATNo Varchar(35),AccContPerson Varchar(100),AccRef Varchar(255),AccCrLimit Money,AccCrDays Numeric(4),AccTANNo Varchar(35),AccKSTNo Varchar(35),TDSYesNo Varchar(3),TDSAccount Varchar(35),JobType Varchar(35),DiscPerc Money,RDPerPcs Money,RDPerMts Money,InsPolicyNo Varchar(35),Dhara Money,DharaDays bigint,TransName Varchar(35), 
                                   AccAdd21 Varchar(100), AccAdd22 Varchar(100),AccAdd23 Varchar(100),AccCityName2 Varchar(35),AccCityPin2 bigint,BlackListed Varchar(1),BankDetail Varchar(255),ExcessRate Money,SeriesName Varchar(40),CommPerc Money, TDSLimit Money,BankName Varchar(35),AccountNo Varchar(35),IFSCCode Varchar(50),Branch Varchar(50),LessDays bigint,PackPerPcs Money,BankCommPerc Money,BankCommLessPerc Money,PackPerMts Money,PostageCharge Money,Taxable Varchar(1),GSTIN Varchar(15),CompScheme Varchar(3),GSTCategory Varchar(15),ECommGSTIN Varchar(15),GSTRegDate DateTime,AccManager Varchar(100), CityDistanceKM bigint,SMAccCode Varchar(7),TCSApplicable Varchar(1),TCSCollectFrom Varchar(15),UdyamRegNumber Varchar(20), EnterpriseType Varchar(20), EnterpriseActivity Varchar(20))