title: How to get a Query Result in a view rather than a execution of a Query?
body: <p>I want to create a View with a lenghty query like : </p>
  
  <pre><code>CREATE VIEW doubleV
  AS 
  SELECT * FROM X1 as R
  WHERE [Ext] IN 
  (
      SELECT [Ext] FROM X1 as RR
      WHERE RR.cliID=R.cliID 
      AND Soc='j'
      GROUP BY [Ext]  
      HAVING COUNT(*) &gt; 1
  )
  </code></pre>
  
  <p>But when i Select all elements from this VIEW, Sql server just execute the query inside the view, which takes much time.</p>
  
  <p>Is it possible to execute the query at the <strong>VIEW CREATION</strong> ?</p>
  
  <p>Does anything would allow me to make a temporary table with a query result ?</p>