title: How to access Temp Table in the stored procedure which is created in another stored procedure?
body: <p>I had an interview in which interviewer asked me a question that how can you access temp table in the stored procedure which is created in another stored procedure and that procedure does not drop temp table?</p>
  
  <p>I answered him that you can access the temp table in a same session. He said but when you will do this:</p>
  
  <pre><code>Select * from #table
  </code></pre>
  
  <p>It will give an error because #table is not created in current SP. I said that you can access temp table in a same session and if both SP's are in same session then you can access that temp table. I did not try this but there will be some way to access it. He said yes you can access it but how? Try it at home.</p>
  
  <p>I know that table created with #table is a temp table. It is only accessible in a same session.  I am trying to access temp table created by other sp in a same session but i am unable to access it. Is there any way to do this?</p>