sql server insert into select
INSERT INTO sales.addresses (street, city, state, zip_code) SELECT street, city, state, zip_code FROM sales.customers ORDER BY first_name, last_name;
Source: www.sqlservertutorial.net
select into insert sql server
INSERT INTO table2 SELECT * FROM table1 WHERE condition;