Return results of mulitple select statements in another Stored Procedure

[jamiemcc]

Hi,

I would like to have 1 stored procedure call another stored procedure
(which contains multiple select statements) and then be able to access
the 3 result sets.

Example
Create Procedure [dbo].[GetValues]
exec Multiple
--manipulate result set A
--manipulate result set B
--manipulate result set C

CREATE PROCEDURE [dbo].[Multiple] AS
Select * from A
Select * from B
Select * from C

I currently have a SP like Multiple, that I call from a VB.Net
application, in the application i can scroll through the 3 resulting
tables. I want to do the same thing from a SQL Server Stored
Procedure.

FYI, tables A,B and C have nothing in common, this is not a place for a
union. I am simply trying to use an SP that was written with ADO in
mind.

Any comments??

Jamiemcc