Multiple Stored Procedure Execute Together - How?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: GJ (GJ_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Wed, 2 Feb 2005 22:13:01 -0800

Hi,

I have multiple stored procedures (SP) running in multiple databases. The
output of all the databases has same column names, same number of columns and
column types.

I want to run all these different SP's as one SP and combine the output as
one result.

I tried creating one new SP as SPAll and calling all the SP's in SPAll.
eg.

Create SPAll @Parameter int
AS
Exec SP1 @Parameter
Exec SP2 @Parameter
GO

But when I execute SPAll from 'sql server reporting services' (vs.net), it
executes and displays results from SP1 also. I want to display results from
both SP1 and SP2.

Thanks in advance.