title: Is WITH the replacement for a #TEMP table?
body: <p>So based off the way I've seen <code>WITH</code> used, and the <a href="http://msdn.microsoft.com/en-us/library/ms175972.aspx" rel="nofollow">documentation at MSDN</a>:</p>
  
  <blockquote>
    <p>Specifies a temporary named result set, known as a common table expression (CTE).</p>
  </blockquote>
  
  <p>it appears that the <code>WITH</code> is the replacement for <code>#TEMP</code> tables. Is that correct?</p>