title: Can I treat the results of a stored procedure like a table?
body: <p>Is it possible to do something like this in sql server 2005?</p>
  
  <pre><code>WITH tmpTable AS (EXEC spWhatever)
  </code></pre>
  
  <p>Or any other way I can query the data returned from the sp? Thanks!!!</p>