title: Stored procedure temporary table problem?
body: <p>I am using stored procedure to extract data from two different databases to a ASP.NET application. My stored procedure work as follows
  - Check if global temporary table exist or not say ##temp_table
  - if exist then drop it and if not create new temporary table say ##temp_table
  - Extract data from two different databases and fill it to Temporary table
  - Select data from temporary table
  - Drop temporary table</p>
  
  <p>Now problem is that when number of users accessing the same page with same stored procedure as above then to some users it get error that temporary table already exist.
  Now please some one help me to solve such problem or suggest me some alternate because I don't want to write query in side ASP code. Some one suggest me to use views. Waiting for your suggestions.</p>