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 - 2000-12-20 : 14:09:15
|
Ron writes "In SQL Server 7.0, I would like to sum individual column values by group and display the results as the sum's relative rank to each group.
For example, Column 1 is month and year, column 2, location, column 3 sales, column 4 expenses, etc. I would want to compute location totals for sales and expenses over several months (ie by quarter or year) and display the location's rank vs. the other locations (1, 2, 3, etc).
Thank you." |
|
|
|
|
|
Displaying aggregates as their absolute numeric rank