RS: multiple SP more performant?

Hi,
If I use for one given Report (Reporting Services) multiple Stored
Procedures as DataSource instead of 1 big Stored Procedure, will this be
more performant or not? Are these multiple sotred procedures executed
simultaneously, of one after the other?
Thanks a lot in advance,
PieterHey Lot of things involved. Stored procedures are executed sequencial if you
have one processor, if you have multiple then it may go as a parallel
execution. Again
it depends if you have complex calculation in single stored procedure then
it may take some time. Otherwise it should not make much of a difference if
it is optimized.
Amarnath
"Pieter" wrote:

> Hi,
> If I use for one given Report (Reporting Services) multiple Stored
> Procedures as DataSource instead of 1 big Stored Procedure, will this be
> more performant or not? Are these multiple sotred procedures executed
> simultaneously, of one after the other?
> Thanks a lot in advance,
> Pieter
>
>