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 |
|
axel503
Starting Member
2 Posts |
 Posted - 2002-04-01 : 20:53:41
|
| Hi,I'm new to the list. I'm trying to get the output of a temporary table into an ASP page. In the stored proc, I create a temp table (#money). I insert some records and do some updates. I then output it with "SELECT * FROM #money. This works in QueryAnalyzer. I use a command to execute the procedure and I set a recordset to the command in ADO like so: Set rsMoney = .ExecuteThe procedure times out during the execute. Anyway, long story short, how do you send the output of a private temporary table in a stored procedure to ASP or ADO?Thanks in advance,Axelr8 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-01 : 20:59:18
|
| HiDO you have SET NOCOUNT ON in your procedure ? Otherwise ADO might not be getting back the right recordset.Damian |
 |
|
|
axel503
Starting Member
2 Posts |
Posted - 2002-04-02 : 11:50:26
|
| No, I don't I'll try that out, Thanks!-Carlo |
|
|
|
|
|
|
Output Temporary Table to ASP