Create Table As (CTAS) in SQL Server

An easy way to create a table based on the output of a select statement on another table in SQL Server is to use the into statement

select fielda, fieldb
into newtable
from originaltable