title: Creating temporary view from a temporary table in SQL Server
body: <p>I have a temporary table and I would like to create a temporary view over this temporary table.</p>
  
  <p>Is it possible?</p>
  
  <p>In following example I would like <code>#Top10Records</code> to be a view instead of a table so that I get </p>
  
  <pre><code>select * into #Top10Records from (select top 10 * from #MytempTable)
  </code></pre>