Inserting Rows by Using SELECT INTO - TechNet - Microsoft

The SELECT INTO statement creates a new table and populates it with the result set of the ... SQL Server 2008 R2.

technet.microsoft.com