Thursday, February 16, 2012

Calculation

I would like to write a query that would perform a calculation and but the
result in a new column.
Example
Value Value_Index Result (Value - Value_Index)
3.5 2.5 1
5 3 2
10 5 5UPDATE V
SET V.Result = (V.Value - V.Value_Index)
FROM tblValues V

No comments:

Post a Comment