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
Author
Message
Posted Monday, July 19, 2010 6:02 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 25, 2013 5:33 PM
Points: 107, Visits: 207
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