G
Gina K
I’m working with an inherited track and field database and trying to clean it
up a little.
Assume the following:
1st place earns 5 pts
2nd place earns 3 pts
3rd place earns 1 pt
4th place and up earn 0 pts
If two are tied for 1st, they split the points for 1st and 2nd (4 pts each).
If two are tied for 2nd, they split the points for 2nd and 3rd (2 pts each).
If three are tied for 1st, they split the points for 1st, 2nd, and 3rd (3
pts each).
There is ALWAYS a total of 9 points awarded.
I’m assigning the places by using a subquery, therefore the “Place†isn’t a
stored value.
Is there a way to count the incidence of each place, and if there’s more
than one (i.e. a tie), then assign the points based on the rules stated
above?
If anyone could point me in the right direction I’d appreciate it.
up a little.
Assume the following:
1st place earns 5 pts
2nd place earns 3 pts
3rd place earns 1 pt
4th place and up earn 0 pts
If two are tied for 1st, they split the points for 1st and 2nd (4 pts each).
If two are tied for 2nd, they split the points for 2nd and 3rd (2 pts each).
If three are tied for 1st, they split the points for 1st, 2nd, and 3rd (3
pts each).
There is ALWAYS a total of 9 points awarded.
I’m assigning the places by using a subquery, therefore the “Place†isn’t a
stored value.
Is there a way to count the incidence of each place, and if there’s more
than one (i.e. a tie), then assign the points based on the rules stated
above?
If anyone could point me in the right direction I’d appreciate it.