Using more then one stored proc

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Using more then one stored proc

Author

Topic

Spence
Starting Member

2 Posts

Posted - 2005-01-13 : 13:50:25

Hey,

Does anyone know if it is possible to use the results from two different stored procedures in the same report or chart, and if so, how would it be done?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-13 : 13:52:51

You can only reference one data set (which would correlate to one stored procedure) in each table that you add. You can create two tables though in a report.

You could combine the results of the stored procedures via another stored procedure:

CREATE PROC SomeProc
AS

CREATE TABLE #Temp1 (Column1 int, Column2 varchar(50)

INSERT INTO #Temp1(Column1, Column2)
EXEC SomeOtherProc1

INSERT INTO #Temp1(Column1, Column2)
EXEC SomeOtherProc2

SELECT Column1, Column2
FROM #Temp1

RETURN
GO

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources