See Re: Can stored procedures return values? Message #876903

>For example I have stored procedure o SQL Server 2000:
>

>CREATE PROCEDURE spTemp_Return (@TempIn integer)
>AS
>RETURN @TempIn * (-1)
>

>
>Is it possible to get value from SP using SQLEXEC function? Or I have to modify my SP to use OUTPUT variables?
>
>Thanks,