Execute SQL Stored Procedure in Different Threads of SQL

In One Stored procedure i m calling two - three different stored
procedure . Can i run sub Stored Procedure (Calling Procedure ) in
different SQL threads . If Yes than how provide sample SQL code
See i m executing one stored procedure in Query analyser but in that
procedure i m calling 5 stored procedue , can i run all this stored
procedure on SQL Different threads for faster processing
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Do the 5 SPs need to communicate with each other. If they dont then you can
create 5 SQLAgent Jobs (one for each of the
5 SPs) and from the main SP you can start the 5 Jobs which would actually
execute the underlying 5 SPs.
Gopinath Rajee
"Dharmesh Doshi" <dharmesh@.sdgsoftware.com> wrote in message
news:uZmN2pnHFHA.2700@.TK2MSFTNGP09.phx.gbl...
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads . If Yes than how provide sample SQL code
> See i m executing one stored procedure in Query analyser but in that
> procedure i m calling 5 stored procedue , can i run all this stored
> procedure on SQL Different threads for faster processing
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!