how to add a select while you are inserting sql code example

Example: insert into select * sql server

INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...
 FROM table1

WHERE condition;