multiple result sets returned from a stored prodedure 
Author Message
 multiple result sets returned from a stored prodedure

Does SQL only pass back once recordset from a stored procedure?

I would like to return multiple recordsets into ADODB and use the
Recordset.NextRecordset method to retrieve them into my application.

The syntax of Recordset.Open() shows multiple SQL statements, but I need the
return of multiple recordsets with the specification of only one SQL
statement(stored procedure).

My original design relied on passing a single parameter of dynamic criteria
and returning 8 recordsets... each one filtered with a temp table created
using the passed criteria.

Thanks.



Tue, 10 Dec 2002 03:00:00 GMT
 multiple result sets returned from a stored prodedure

You can pass back multiple recordsets from a stored procedure, Mark.


Quote:
> Does SQL only pass back once recordset from a stored procedure?

> I would like to return multiple recordsets into ADODB and use the
> Recordset.NextRecordset method to retrieve them into my application.

> The syntax of Recordset.Open() shows multiple SQL statements, but I need
the
> return of multiple recordsets with the specification of only one SQL
> statement(stored procedure).

> My original design relied on passing a single parameter of dynamic
criteria
> and returning 8 recordsets... each one filtered with a temp table created
> using the passed criteria.

> Thanks.



Thu, 12 Dec 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. return multiple result sets from a stored procedure

2. How not to return multiple result sets from a stored procedure

3. Stored Procedure/Multiple Return Results/Set Statement

4. Returning Multiple Result Sets for Java Stored Procedures

5. Saving and Returning Multiple Result Sets

6. Returning Multiple Result Sets

7. Returning Multiple Results Sets From a StoreProc

8. Query returned multiple result sets

9. returning result sets from stored procedures

10. Returning result sets in oracle stored procedure (OLEDB)

11. Can't update result set returned from stored procedure using RDO

12. Returning result set from function to stored procedure is very slooooooooow


 
Powered by phpBB® Forum Software