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-11-29 : 10:07:15
|
| Keith Lim writes "Ok, straight to the Q.I need to create a temporary table in a Stored Procedure, do some processing and populate this table accordingly, then return the content of this table in a recordset. I HAVE to use ADODB object to call this Stored Procedure, in either VC++ or VB.The problem exist in, after I populate the table and return the content using the Execute method of Command object, it SHOULD return a valid recordset object in my application, but it just doesn't. If I use Query Analyzer to run this Stored Procedure, it does return the correct recordset to me.Anyone have any idea?Thanks in advance." |
|
|
|
|
|
Populating temporary table?