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 - 2006-01-30 : 13:44:55
|
| Azad writes "I've read your article .. http://www.sqlteam.com/item.asp?ItemID=2029 .. which talks about making a temp table in sp.. My question is how do I retrieve the temp table in my ASP code so I can get a filtered list in asp.For example. I might have 5 tables in SQL and the SP will do few calculations and narrow down to 1 table with only required fields and also with alot of filtration. And I store that as a temp table at the end of the stored procedure. Now is there a way to retrieve that temp table when I am calling that SP from my ASP?I am asking this because this is possible in Crystal Reports and I want to use this feature also in my ASP code. Please let me know.Thanks-Azad" |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-30 : 13:49:02
|
Let ur connection object be adoCon, and recordset object be rsSet rs = adoCon.execute ("Ur SP Name")Then u can use rs as any other recordset |
 |
|
|
|
|
|
SQL Temp Table > ASP output.