Subject | To calculate... |
---|---|
Author | Marcelo Machado |
Post date | 2005-11-04T20:01:13Z |
Dear friends,
To calculate 27 fields I do need " to write " all (see example) or does some exist formula that calculates of " such a " until " such "?
ALTER TABLE new table
ADD TOTAL COMPUTED BY (V1+V2+V3+V4... )
OR
ALTER TABLE new table
ADD TOTAL COMPUTED BY (V1 ? V27)
[ ? = some formula]
Thanks
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
[Non-text portions of this message have been removed]
To calculate 27 fields I do need " to write " all (see example) or does some exist formula that calculates of " such a " until " such "?
ALTER TABLE new table
ADD TOTAL COMPUTED BY (V1+V2+V3+V4... )
OR
ALTER TABLE new table
ADD TOTAL COMPUTED BY (V1 ? V27)
[ ? = some formula]
Thanks
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
[Non-text portions of this message have been removed]