Update column value based on procedure output 1

[Mich]

I have a very long and very complex stored procedure that produces a dollar amount given parameterized values. I have inserted into a temp table all values that will be passed to the procedure. This temp table has one more column that I need to populate with the OUTPUT of the stored procedure. I'm having a hard time getting this to work. Below is a simple example of what I'm trying to do.

exec proc_AddItUp 1,2,3, @total OUTPUT

The procedure's logic returns @total=6. I have a temp table with fields such as,

FirstVal     SecondVal     ThirdVal     Total
   1             2            3
   2             3            4
   3             4            5

I need to update the Total column with the output of the procedure using the first three columns as input.

Suggestions??

Thanks in advance.

-If it ain't broke, break it and make it better.

 

[RiverGuy]

Convert the procedure into a user-defined function returning a scalar value, and call it in the following way:

UPDATE #TempTable
SET Total = dbo.udf_AddItUp(FirstVal, SecondVal, ThirdVal)

 

[Mich]

Perfect example of trying to use a screwdriver instead of a hammer. Thanks for the direction.

-If it ain't broke, break it and make it better.