title: What are the Main difference between CTE's and TEMP tables?
body: <p>Is there a benefit to using <code>CTE's</code> (<code>common table expressions</code>) instead of using <code>temp tables</code>. </p>
  
  <p>I went through performance testing between both of them, but I cant find much difference between them. </p>
  
  <p>What are some pros and cons of using <code>CTE'S</code>?</p>