Try to create a table from Select - SqL Server 2008 throws error ...

I'm almost positive that SQL Server doesn't have a CREATE TABLE AS (SELECT. .. syntax, but you can use ...

stackoverflow.com