Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Obtaining Results from Netsted Stored Procedure Expand / Collapse
Posted Monday, July 19, 2010 6:02 AM



Group: General Forum Members
Last Login: Tuesday, October 6, 2015 5:00 PM
Points: 108, Visits: 220
I have a master stored procedure called the conductor that does some general work with input parameters and then hands off a tighter parameter list to one of 6 stored procedures that will return a result set.

Using SSRS to display the results is a business mandate, but I do not believe that I'll be able to get results from a nested stored procedure as reporting services would not be able to define the column list a priori.

Has anyone dealt with such an issue, and if so, what path did you take?

Keith Wiggans
Post #954758
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse