Calling Stored Proc from a Stored Proc-Help!

[aspengal]

Hi Friends,

I would like to Call SP2 from SP1. SP2 will exeucute and pass an output parameter back to SP1. can someone pls. help me with the syntax?

In SP2, I will declare var_out_param and assign a value to it. I need to validate this value in SP1.

Is it " exec SP2(var_out_param)"???

Help!

 

[NoCoolHandle]

Create proc a
@a int,
@b int output
as
set @b = @a * @a
go
Create proc b
@a int,
@b int output
as
exec a @a, @b
go
declare @o int 
exec a 3,@o output
select @o

 

[NoCoolHandle]

So do you live in the roaring fork valey?