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 |
|
swmiller6
Starting Member
1 Post |
 Posted - 2002-06-11 : 10:38:52
|
| I am not sure if this is the place to post my question but I am using a MS access database. I have a member_Info table that holds Three columns, cloumn one is Season_Stats, Column two is Weekly_Stats and column three is Current_position. The Season_Stats coulmn has the weekly_Stats coulmn added to it at the end of every week. I need to number the current_position column 1st,2nd,3rd, ect. descending from top to bottom (member with highest number in season_stats to member with the lowest number) and update the Current_Position column accordingly. I am not sure where to start or if it is even possible to do what i want to do, any ideas or a point in the right direction would be greatly appreciated. |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-21 : 13:05:01
|
| Hmmm, interesting bit here. I actually recommend you take a look at how you are handling the current_position column. Instead of actually storing this number in your database, I think you should drop the column. Make it so this position is constantly calculated on the fly. Heres what I mean :select season_stats,weekly_statsfrom member_infoorder by season_stats descmight be asc.. whatever you want.Key thing here is your not actually storing the ranking inside the table. Its just calculated and ordered by as you go.-----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
Comparing data from the same table?