Running a stored procedure from an other

dear all
i need to execute a stored procedure in sql server from another stored
procedure.
this mean that my application calls a stored procedure but i need when i
call this stored proceure to run an other one.
is that possible and can anybody help me to acheive this task'
Thank you.GMK wrote:
> dear all
> i need to execute a stored procedure in sql server from another stored
> procedure.
> this mean that my application calls a stored procedure but i need
> when i call this stored proceure to run an other one.
> is that possible and can anybody help me to acheive this task'
> Thank you.
Sure it's possible. Just execute the other proc:
From Proc1
Exec dbo.Proc2 @.param1, @.param2
If you need a return value, then use:
Exec @.iRet = dbo.proc2 @.param1, @.param2
David Gugick
Imceda Software
www.imceda.com|||exec sp_name @.ParameterName = @.ParameterValue, ...

> dear all
> i need to execute a stored procedure in sql server from another stored
> procedure.
> this mean that my application calls a stored procedure but i need when
> i
> call this stored proceure to run an other one.
> is that possible and can anybody help me to acheive this task'
> Thank you.
>

Run SQL Query on Different Thread 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
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Dharmesh Doshi wrote:
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can kick off multiple jobs to to this. You can also call the
procedures from your app asynchronously from ADO or kick off multiple
threads if your app uses .Net.
If Proc1 calls Proc2 and Proc3, though, and I needed to run them
asychronously, I might kick them off separately from the app once Proc1
completed. Or you can create jobs in Proc1 that kick off and immediately
run Proc2 and Proc3.
David Gugick
Imceda Software
www.imceda.com

Run SQL Query on Different Thread 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
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Dharmesh Doshi wrote:
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can kick off multiple jobs to to this. You can also call the
procedures from your app asynchronously from ADO or kick off multiple
threads if your app uses .Net.
If Proc1 calls Proc2 and Proc3, though, and I needed to run them
asychronously, I might kick them off separately from the app once Proc1
completed. Or you can create jobs in Proc1 that kick off and immediately
run Proc2 and Proc3.
David Gugick
Imceda Software
www.imceda.com