Stored Procedure output

• b_boy

  SSCertifiable

  Points: 5145

  More actions

  February 8, 2008 at 10:24 am

  #186361

  Does any one now the syntax to input the outut of a stored procedure into a tabel for it to be used by SSRS?

• Kenneth.Fisher

  SSC-Insane

  Points: 20406

  More actions

  February 8, 2008 at 11:59 am

  #776550

  Insert the output of a SP into a table like this:

  INSERT INTO TableName (FieldList)

  EXEC StoredProcedure

  I didn't realize there was anything special you needed to do with SSRS to access a table?

  Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  February 8, 2008 at 1:19 pm

  #776584

  b_boy (2/8/2008)

  ---

  Does any one now the syntax to input the outut of a stored procedure into a tabel for it to be used by SSRS?

  In your dataset, you can specify to use a stored procedure. Just path out the procedure name without an execute and you'll get the resultset in SSRS.