title: Stored procedure deleting temporary table
body: <p>I have a stored procedure which makes used of a temporary table with <code>##temp</code> creating on the fly using <code>select * into ##temp from tablename</code>.</p>
  
  <p>The problem I have having is this stored procedure seems to delete or make this available only for that moment in time when the query is ran, despite having <code>##</code> which is global and can be used by other users from what i know.</p>
  
  <p>I am using SSRS to pull the stored procedure and using drill through from this report to the same report, first one only showing charts, the second report which is the same stored procedure which uses the actions link via parameter but the second report doesn't recognize the <code>##temp</code> table. </p>
  
  <p>Now that you got the background, is there a way around this or a better way of doing it, keep in mind we don't have a data warehouse at the moment, so just using temporary tables to do the work around.</p>
  
  <p>Thanks</p>