Hi all,

I'm trying to retrieve several sets of data from an unique stored
procedure.

For example, the following stored procedure:
CREATE PROCEDURE getOrder @MY_ID int
AS
SELECT * FROM orders where order_id = @MY_ID
SELECT * FROM orders_details where order_id = @MY_ID
GO

called by: insert command "getOrder 1234"

just returns the first set of data.

Is there a way to retrieve the two sets?

Franck.
--
To unsubscribe from this list, please send an email to
[EMAIL PROTECTED] with "unsubscribe" in the
subject, without the quotes.

Reply via email to