insert into COMMON.DBO.COMPANY_DETAIL 

SELECT     CompCode, CompName, CompOpeningDate, CompClosingDate, CompYear, 'OPEN', 'NEW'
FROM         COMPANY_DETAIL