469,898 Members | 1,563 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Return results of mulitple select statements in another Stored Procedure

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

Jul 23 '05 #1
0 1927

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jeff Mason | last post: by
6 posts views Thread by Lauren Quantrell | last post: by
2 posts views Thread by Rhino | last post: by
2 posts views Thread by =?Utf-8?B?VGVycnk=?= | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.