INSERT INTO table1 ( column1 )
SELECT col1
FROM table2
Like:
insert into property.portfolio_property_xref
(
portfolio_id ,
building_id ,
created_date ,
last_modified_date
)
select
34,
building_id,
getdate(),
null
from
#temp_buildings