By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,508 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,508 IT Pros & Developers. It's quick & easy.

Return results of mulitple select statements in another Stored Procedure

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.