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 - 2001-08-15 : 00:33:01
|
| Erik writes "I have some code and a database I am working with. In the record there is a field labeled Rank. What I am wanting to do is when the the Rank in one Record is changed all the others will update.Example:Tom's Vote Rank 4Bob's Vote Rank 5Joe's Vote Rank 6Jay's Vote Rank 7Mac's Vote Rank 8Now the database updates and now Jay is ranked 4thJay's Vote Rank 4Tom's Vote Rank 4Bob's Vote Rank 5Joe's Vote Rank 6Mac's Vote Rank 8When Jay's rank is set to 4 how do I update all ranks > 4 so that all will count from 4.. so tom would go to 5 bob 6 joe 7Now as the database grows say somebody ranked in the 100's jumps up to the 20's or 30's. Then you have about 50+ records to update and all in mere seconds so when they check the rankings they will be ready.If you could offer any help I would appreciate it." |
|
|
|
|
|
Updating a field in a record that in turn updates all the fields in all the other records.