INSERT INTO insertTable (x, y, z)
SELECT x, y, z
FROM a INNER JOIN b ON a.id = b.id
This format will work fine. Do the Sql with the join and add the first line at the top to make an insert of it.
create table t1
(
id int,
val varchar(5),
dt datetime
)
create table t2
(
id int,
val varchar(5)
)
insert into t2 values(1,'test')
insert into t2 values(2,'check')
insert into t1
select id, val, getdate() from t2
select * from t1
This will output:
1 test 2013-12-30 21:17:42.117
2 check 2013-12-30 21:17:42.117
with what ever the time is there. You can replace getdate() with your parameters, in other words, all you need to do, is add them to the select list and this will work as you asked.