Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-07 : 12:08:00
|
| Gilbert writes "Hi SQLTeam,I have some information that I'd like to be able to calculate and store the results in the same table. For example:Account Number | Amount ------------------------1000 | $5000 1200 | $5236Total | $10236 The Total cell would be in the Account Number slot but it would store the sum of account numbers 1000 and 1200. As opposed to using a query to display the total, I would like to be able to just store the data in the table, redundant though it may be.I'm using SQL 2000 Enterprise running on windows XP.Would appreciate any help.Gilbert" |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-06-07 : 12:52:11
|
| GilbertIf you did store the totals on the table in this way, how would you know to which account it belonged ?Graham |
 |
|
|
|
|
|
Calculated rows