Hi,

Is it possible to assign an return value from an Stored Proc to a variable locale.

My first SP return a value.
I want that my second SP exec that first SP in the second.

Example:
Declare @x int
set @x = exec SP1
select @x

I got an error.

Thank in advance.