title: Create Table from View
body: <p>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:</p>
  
  <pre><code>CREATE TABLE A 
  AS
  (SELECT top 10 FROM dbo.myView)
  </code></pre>
  
  <p>So far the error is: "syntax error at 'as'" </p>
  
  <p>View is too large. Is it possible to use a top 10?</p>