Obtaining Results from Netsted Stored Procedure

• kwiggans

  Ten Centuries

  Points: 1196

  More actions

  July 19, 2010 at 6:02 am

  #224254

  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