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
Thursday, February 16, 2012
Calculation
Labels:
calculation,
column,
database,
examplevalue,
microsoft,
mysql,
oracle,
perform,
query,
server,
sql,
theresult,
value,
value_index,
write
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment