dz2k7
Not only User
- Local time
- Today, 04:13
- Joined
- Apr 19, 2007
- Messages
- 104
Hi everybody,
I've got 250 branches. I need to rate them by sales descending.
So I did a query to figure out their sales and sort them.
Now I need to give a rating to each branch in this table starting from 1000 down.
How to do that?
If I put the key on it it's not going to be sorted right.
Is there any function to figure out the actual position of the record in a table and how to update it?
I've got 250 branches. I need to rate them by sales descending.
So I did a query to figure out their sales and sort them.
Now I need to give a rating to each branch in this table starting from 1000 down.
How to do that?
If I put the key on it it's not going to be sorted right.
Is there any function to figure out the actual position of the record in a table and how to update it?
