Hi,
I have a procedure that creates the global temp table (##temp) inside a procedure which is populated with data when it is run for the first time. And when the procedure is executed second time, it uses that temp table instead of loading it all over.
The trouble I am having is that when I execute the procedure from Asp.NET the temp table stays there as long as i call the same procedure, but as soon as I call another procedure the temp table gets deleted even if I use the same object to execute the procedure.
Hope someone can help me in this. I dont know what is happening in here, I am lost.
Thanks In advance, hope to hear from you guys soon.
cheers.