Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing multiple result sets in SP from another SP

Status
Not open for further replies.
jaycast

jaycast

Programmer
Nov 28, 2001
42
0
0
US
I have a situation in developing with a 3rd-party reporting app that limits my SP result set access to one result set per SP. The SP I'm trying to access returns multiple result sets, so I was thinking of writing a passthrough SP to the base SP to pull the specific result set that I need based on a passed parameter.

Is this at all possible, and if it is, what would be the syntax to access a result set "indexer" from another SP?
 
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
226
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
132
Chris Miller
Chris Miller
bharons
  • Question
Pick up value from combobox
Replies
0
Views
141
bharons
bharons
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
105
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
103
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top