Some have asked to see a percentage. This is not feasible to have a sort by this because someone could easily pick the 'locks' and get a high percentage. But for fun, I threw together a query and got something to show for kicks.


Name Picks Correct
OSOGRANDE 16 12 75.00%
OlHoss1884 90 61 67.78%
dhazer 93 63 67.74%
Maverick 93 61 65.59%
gbguy20 63 41 65.08%
Wade 62 40 64.52%
steveishere 64 41 64.06%
buckeyepackfan 93 59 63.44%
wpr 93 59 63.44%
Zero2Cool 93 59 63.44%
Tezzy 90 57 63.33%
Gaycandybacon 32 20 62.50%
gbpfan 16 10 62.50%
Pack93z 93 58 62.37%
yooperfan 92 57 61.96%
macbob 76 47 61.84%
rlyon 44 27 61.36%
porky88 75 46 61.33%
The_Green_Ninja 15 9 60.00%
hardrocker950 93 55 59.14%
GoPack1984 93 54 58.06%
GermanGilbert 75 43 57.33%
beast 93 53 56.99%
SINCITYCHEEZE 93 50 53.76%
DoddPower 16 8 50.00%



boy do I stink when it comes to picking.
I will stay out of Vegas.

Might want to check that query... Wayne has made over 200 picks? [grin1]

Pack93z;259888Might want to check that query... Wayne has made over 200 picks? [grin1]

When you make 214 picks on September 10th, 2013, that'll be the case.
The query takes all picks made and doesn't use a parameter for 'up to' the current week.

Zero2Cool;259892When you make 214 picks on September 10th, 2013, that'll be the case.
The query takes all picks made and doesn't use a parameter for 'up to' the current week.

Ahh... so he has filled in his picks for the year already forward.. makes sense.. but it also highlights a problem as well.. the picks for this week are going to be misses as there is no result yet.

Can it be queried if the winning/correct team is not null?

Pack93z;259893Ahh... so he has filled in his picks for the year already forward.. makes sense.. but it also highlights a problem as well.. the picks for this week are going to be misses as there is no result yet.

Can it be queried if the winning/correct team is not null?

Yes sir.
It's more so just a glimpse that it can be done. I had a stumbling block on a work project and my mind went awry. :)

The structure of the database tables ... has room for improvement, but still offers a lot of flexibility to do as you suggest.

Easiest addition would be to add a condition that

AND GameDateTime < GetDate()

I think that would ensure the game has to be played or ... my mind just went blank. Lost my thought. I'll come back later if it comes back.

LOL.. know the blank mind feeling.. people at times walk in here and I am probably zombie like.. lost in thought.. code or something.. lol.

Zero2Cool;259892When you make 214 picks on September 10th, 2013, that'll be the case.
The query takes all picks made and doesn't use a parameter for 'up to' the current week.

swell now everyone will want to pick early.

BTW- does it change the data above when I come back and revise my picks later?
(That is not counted as selecting twice?)

wpr;259905swell now everyone will want to pick early.

BTW- does it change the data above when I come back and revise my picks later?
(That is not counted as selecting twice?)

Yes.

Zero2Cool;259906Yes.

Since I have voted early, over the course of the season I have changed my vote on a few games each week.