Create temporary or regular table with SELECT INTO
September 26, 2000
The SELECT INTO statement is a combination of the SELECT and INSERT T-SQL commands, that lets you create a new table from a subset of the rows and/or the columns