>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.
Dave,
Please see
How to return a value from dynamically executed T-SQL code FAQ #8130
UPDATE. Never mind, misread your question.
If it's not broken, fix it until it is.
My Blog