The reason for this is because you are returning results from a temporary table. And when the procedure completes, the #temporary table goes out of scope. 

So when your...

Heres something I found. Dunno if it helps or not

https://msdn.microsoft.com/en-us/library/aa260844(v=vs.60).aspx