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.
>