Calling stored procedure from another stored procedure

Is it possible to call one sp from another sp?
I've been hunting around for an example to do this and just can't seem to find one.
Anyone have a link for this or a sample?
Thanks all,
Zath

Yes, you can. Just use EXEC usp_secondStoredProc @.params inside your first SP.

Nick

Call a SP many times in parallel

Hi,

Is there a way to call a SP several times in parallel from another SP?

I know I can create a DTS with several Tasks that work parallel. The issue is that I don't know how many parallel execution I need.

Thanks,

Assaf

No. Execution of the SP is always sequential.