title: tsql sql multiple temp tables with same name
body: <p>I'm working on a Report using RDL files and stored procedures.
  RDL file name is test.rdl and I have four(4) stored procedures connected to this test.rdl file. so this file will have four datasets.</p>
  
  <h2>report file name:</h2>
  
  <p>test.rdl</p>
  
  <h2>stored procedure names:</h2>
  
  <ul>
  <li>sp_test_1</li>
  <li>sp_test_2</li>
  <li>sp_test_3</li>
  <li>sp_test_4</li>
  </ul>
  
  <p>each of these stored procedures have temp tables with same name(#temp).</p>
  
  <pre><code>create table #temp(
  ID int,
  Name varchar(max),
  Location varchar(max)
  )
  
  insert into #temp
  
  select * from anothertable where date between '20171001' and '20171031'
  </code></pre>
  
  <p>some more extra queries to get the desired result and then finally drop the temp table.</p>
  
  <p><code>select . . . . . . . . . .</code></p>
  
  <pre><code>drop table #temp
  </code></pre>
  
  <p>so all of the four stored procedures have temp table using one name(#temp).</p>
  
  <p><strong>so my question is, will this work fine when the RDL test file is ran and when all of the four(4) stored procedures are called at once?
  my concern is with the #temp table, all four stored procedures have drop table #temp at the end of the run. will this affect the filling of the temp tables during runtime as one of the stored procedures may finish with drop table while the other one was running hence resulting in cancelling of query or finishing with incomplete results?</strong> </p>
  
  <p>can some please explain. I hope this is a valid question.</p>