title: Can I recreate a temp table after dropping it?
body: <p><strong>Given:</strong></p>
  
  <p>code inside a stored proc:</p>
  
  <pre><code>select bleh
    into #tblTemp
    from FunctionThatReturnsTable('some','params')
  
  -- do some stuff
  
  drop table #tblTemp
  
  -- Error on this command:
  -- 'There is already an object named '#tblTemp' in the database.'
  select bleh
    into #tblTemp
    from FunctionThatReturnsTable('some','other params')
  </code></pre>
  
  <p><strong>Problem:</strong></p>
  
  <p>I can't recreate this temp table. My work around is to use #tmpTable1, #tmpTable2, #tempTable3 etc. Is there a way I can get around this? It would be nice just use one temp table each time. </p>
  
  <p>If not, what is the reason for this?</p>