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,
--sb--