G
Guest
I was quite interested in some SQL I saw earlier in this site from Allen
Browne and John Spencer. If the poster is OK with this, I'd like to steal it
for my app that deals with ping-pong tounaments. The SQL involved
SELECT........ (SELECT Top 3 ....) ...
Here is what I'm trying to do. when we have tournaments with only a handful
of games, we base the team award on the top 3 scores. But if there are many
teams and many games in a large touney, I'll base the team award on the top 4
or even 5 scores. Instead of determining the team award by hand as I now do,
I'd like my scoring app to have a combox with a value list of 3,4,5. Here
is my question - how do I chose 4 from the combox, for example, then get the
SQL to return Top 4, not Top 3?
Thanks to the contributors of this site
Browne and John Spencer. If the poster is OK with this, I'd like to steal it
for my app that deals with ping-pong tounaments. The SQL involved
SELECT........ (SELECT Top 3 ....) ...
Here is what I'm trying to do. when we have tournaments with only a handful
of games, we base the team award on the top 3 scores. But if there are many
teams and many games in a large touney, I'll base the team award on the top 4
or even 5 scores. Instead of determining the team award by hand as I now do,
I'd like my scoring app to have a combox with a value list of 3,4,5. Here
is my question - how do I chose 4 from the combox, for example, then get the
SQL to return Top 4, not Top 3?
Thanks to the contributors of this site