The indexes on a the tables of a large database make a ... How to Create a Table From Query Results in Microsoft SQL How to Create a Table From Query Results in Microsoft SQL.

This method isn't ANSI-standard SQL, but Microsoft's Transact-SQL extension includes this handy feature. Creating a new table from query results can help you build a database of your clients ...