Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-20 : 22:58:10
|
Murtaza writes "I m calling stored procedure via asp which creates temp table and
insert data into it on certain criteria ( here i m passing sql statement as parameter to stored proc). when i call that temporary table to my asp page. it display error msg something like (object not found). I read in the manual that temporary tables drops after stored procedure execution. now, plz guide me how to get data from that temp table (or stop him dropping after. i couldn't use different approach bcoz there may be 45,000 records in the table" |
|
|
|
|
|
how to retreive data from temp table (i.e. used with #)