Insert select pada SQL Server

Contoh :

select AJH_ID, '20249'  AJD_Emplcode , AJD_LevelCheckID, AJD_Status ,'kusdi' AJD_Username,  getdate() AJD_LastUpdate ,  ajd_checkdetail
from  tm_accessjeisdt
inner join tm_accessjeishd a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=20472

kemudian tambahkan didepan select secript insert

Menjadi :

Insert into tm_accessjeisdt (AJD_HeaderID, AJD_Emplcode, AJD_LevelCheckID, AJD_Status , AJD_Username,  AJD_LastUpdate ,  ajd_checkdetail)
select AJH_ID, '20249'  AJD_Emplcode , AJD_LevelCheckID, AJD_Status ,'kusdi' AJD_Username,  getdate() AJD_LastUpdate ,  ajd_checkdetail
from  tm_accessjeisdt
inner join tm_accessjeishd a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=20472