February 8, 2008 at 10:24 am
Does any one now the syntax to input the outut of a stored procedure into a tabel for it to be used by SSRS?
February 8, 2008 at 11:59 am
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]
February 8, 2008 at 1:19 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply