>I need to return a money value from a stored procedure. I cant use a function because the procedure does an insert and an update. I can't use a stored procedure because return will only return integer, and if i use a select statement then i can't capture the value for further use in my calling procedure. What would be the best way to accomplish this?

Use OUTPUT parameter:

create procedure MyProc 
(
@parameter1 (type here),
...
@returnpar money OUTPUT
)
AS
  begin
    SELECT @returnpar = NeededColumn FROM MyTable WHERE ....
  END

Then you just can do (in QA)

DECLARE @TestMoney money
EXEC MyProc (parameters here w/o output one), @TestMoney OUTPUT
print @TestMoney