I'll try to explain in better detail:

Create Procedure p_myproc1

Begin

SELECT 1

End

--- Proc 1 just returns a value of 1 through a select...

I tried that code, its actually executing the procedure and returning it as a result from the

calling stored procedure. I need it to just put the value into @Result...

That works, I left out one part, I have to sum the most recent 500, the query would look like this:

select TOP 500 Convert(money,SubString(strrow,8,5) from tComments where strrow like '%Value:%'...