insert into #tbl_temp select col1 from ( insert into tbl_1(col1,col2) output Inserted.col1 select col3, col4 from tbl_2 ) as T where T.col1 > 0