EXEC @x = SP1
>
>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.
--sb--