⬅ Back UPDATE LAST YEAR FIRM TO CURRENT YEAR - AGENCY.txt

insert into t202627.dbo.company_detail select * from t202526.dbo.COMPANY_DETAIL where CompCode not in (select CompCode from T202627.dbo.COMPANY_DETAIL)