I have a view that I want to create a table from in SQL Enterprise Manager, but I always get an error when I run this query:
CREATE TABLE A
(SELECT top 10 FROM dbo.myView)
SQL Server does not support
CREATE TABLE AS SELECT.
SELECT * INTO A FROM myview
SELECT TOP 10 * INTO A FROM myview ORDER BY id