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 SELECT statement. ... SQL Server 2008 R2 ... To insert rows into a partitioned table, you must first create the partitioned table and then use the INSERT ...

technet.microsoft.com