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-02-25 : 10:59:19
|
chitts writes "Hi friends...
I have created a stored procedure.In this i have used a temporary table. The problem is that when i give a
select field1,field2 from #temporarytable1
outside the stored procedure i am not able to retrieve the data.
It works good inside the stored procedure... why it so???
and the other problem is...
When i retrieve the data from my asp page.. it gives an error message. like this
ADODB.Recordset error '800a0e78'
The operation requested by the application is not allowed if the object is closed.
/cissharedapps/satya/chitts/mynoti/results.asp, line 276
How could i retrieve the data from asp page...
Advance thanks for yr help
Chitts" |
|
|
|
|
|
retrieving data from temp tables...