title: Write result of query into a new table
body: <p>How can I write the result of the SQL Server query, displayed in this question : <a href="https://stackoverflow.com/questions/33083918/transform-a-table-from-rows-to-columns">Transform a table from rows to columns</a>, into a new table?</p>
  
  <p>I tried the following, but it isn't working:</p>
  
  <pre><code>SELECT * INTO [dbo.table] FROM query;
  </code></pre>