Hi All,

I'm wondering if you can use an EXECUTE statement to retrieve an output variable and use that in an UPDATE sql statement. I'm getting errors and admit I'm not experienced enough to know if it is my syntax or if I'm trying the impossible.

Right now my test code looks like this:

UPDATE tblTestCost SET cost = (EXECUTE spGetCost var1*, @Cost OUTPUT)

*var1 is a field from tblTestCost

Possible maybe, but not this way?

Thanks for any comments offered,