insert into select sql server

Take a break and read all about it