Sql Calculated
Sql Calculated
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
‹
›
Home
View web version
No comments:
Post a Comment