title: Is it possible to have temp tables in a function?
body: <p>Apparently, I can't use them. I'm getting an error message like:</p>
  
  <blockquote>
    <p>Invalid use of a side-effecting operator 'SELECT' within a function</p>
  </blockquote>
  
  <p>If I want to do something like this:</p>
  
  <pre><code>select bleh
    into #temp
    from Blah
  </code></pre>
  
  <p>... inside a function.</p>