This method won't work in SQL Server, but Microsoft's ... ... How to Create a Table From Query Results in Microsoft SQL.
smallbusiness.chron.com