Zero2Cool
11 years ago
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%


UserPostedImage
wpr
  • wpr
  • Preferred Member
11 years ago
boy do I stink when it comes to picking. I will stay out of Vegas.
UserPostedImage
Pack93z
11 years ago
Might want to check that query... Wayne has made over 200 picks? [grin1]
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
11 years ago

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

Originally Posted by: Pack93z 



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.
UserPostedImage
Pack93z
11 years ago

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.

Originally Posted by: Zero2Cool 



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?
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
11 years ago

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?

Originally Posted by: Pack93z 



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.
UserPostedImage
Pack93z
11 years ago
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.
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
wpr
  • wpr
  • Preferred Member
11 years ago

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.

Originally Posted by: Zero2Cool 



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?)


UserPostedImage
Zero2Cool
11 years ago

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?)

Originally Posted by: wpr 



Yes.
UserPostedImage
wpr
  • wpr
  • Preferred Member
11 years ago

Yes.

Originally Posted by: Zero2Cool 



Since I have voted early, over the course of the season I have changed my vote on a few games each week.
UserPostedImage
Users browsing this topic
    Fan Shout
    Zero2Cool (12h) : Jaire played in just 34 of a possible 68 games since the start of the 2021 season
    Zero2Cool (12h) : reported, but not expected to practice
    Zero2Cool (12h) : Jenkins has REPORTED for mandatory camp
    Zero2Cool (13h) : I really thought he'd play for Packers.
    buckeyepackfan (13h) : Packers releasing Jaire Alexander.
    Mucky Tundra (8-Jun) : (Context: he wants his defense to create turnovers)
    Mucky Tundra (8-Jun) : Giants DC Shane Bowen tells players to “be a damn pirate."
    dfosterf (6-Jun) : Semper fi !
    Cheesey (6-Jun) : This is why I have so much respect for those that have gone through battles
    Cheesey (6-Jun) : I can't even imagine what that would have been like
    wpr (6-Jun) : "Come on, you sons of bitches. Do you want to live forever?"
    wpr (6-Jun) : Facing a line of machine guns 2 time medal of Honor recipient, First Sergeant Dan Daly told his men,
    wpr (6-Jun) : Another detachment went into the Belleau Wood.
    wpr (6-Jun) : On the 6th the Marines took Hill 142 but suffered terrible losses.
    wpr (6-Jun) : It’s time to remember dfoster’s Marine brothers in Belleau Wood. The battle went on from June 1-26. Nearly 10,000 casualties.
    packerfanoutwest (6-Jun) : Nick Collins and Morgan Burnett have signed with the PACK
    packerfanoutwest (6-Jun) : he won't be wearing #12, maybe he will wear number two
    packerfanoutwest (6-Jun) : He will fail this season, should have retired
    Mucky Tundra (5-Jun) : Thus the cycle of Hall of Fame Packer QBs going to the Jets and then the Vikings is broken
    bboystyle (5-Jun) : Rodgers to steelers on 1 year contract
    Zero2Cool (5-Jun) : It's the cycle of civilizations. Get lazier, lazier, softer, softer and vanish.
    Martha Careful (5-Jun) : great point. every aspect of society, including art, culture and sports has degraded.
    dfosterf (4-Jun) : Green Bay sweep meant something to society about stopping pure excellence. We have the tush push now
    dfosterf (4-Jun) : We old Martha.
    Martha Careful (4-Jun) : *front four
    Martha Careful (4-Jun) : Re frout four, I wish we had some Green "People Eaters" or a fearsome foursome
    dfosterf (4-Jun) : *directions*
    dfosterf (4-Jun) : Just don't ask him for driving direct
    dfosterf (4-Jun) : Jim Marshall was an all-time great DE for the Purple People Eaters. Didn't like him. That's a compliment. RIP
    Zero2Cool (3-Jun) : ooppppss
    Zero2Cool (3-Jun) : “Kenny Clark played all of last season hurt by the way and got surgery to fix it in January”
    Mucky Tundra (3-Jun) : @ByRyanWood How much did the injury affect him last fall? “A lot.”
    Mucky Tundra (3-Jun) : @ByRyanWood Kenny Clark said he had foot surgery in January. Injured his foot in opener against Eagles and played through it all year.
    Zero2Cool (3-Jun) : Golden is wearing guardian cap again. I bet he plays with it on too.
    Mucky Tundra (3-Jun) : All the stuff I'm reading from Lions fans are pointing at his toe; he more or less has permanent turf toe in one of his big toes
    dfosterf (3-Jun) : Kenny played through it, and a shame he gets little credit for that, imo
    dfosterf (3-Jun) : Big men. I hope it's not the undoing of Kenny Clark
    dfosterf (3-Jun) : Probably his toe. Pretty much a great center. Toe injuries are brutal to bigen
    Mucky Tundra (2-Jun) : Lions All-Pro C Frank Ragnow retires
    wpr (30-May) : It's all good.
    beast (30-May) : Yeah, and I enjoyed your comments and just attempted to add to it. Sorry if I did it incorrectly.
    wpr (30-May) : Beast I never said Henderson was the salt of the earth. Nor even that he was correct. Just quoting the guy.
    Zero2Cool (29-May) : What did you do??
    Zero2Cool (29-May) : Whoa
    beast (29-May) : OMG the website is now all white, even some white on white text
    beast (29-May) : Henderson, who admits to taking cocaine during the Super Bowl against the Steelers, might dislike Bradshaw as he lost two Superbowls to him
    wpr (28-May) : Hollywood Henderson said Bradshaw “is so dumb, he couldn't spell 'cat' if you spotted him the C and an A.”
    Mucky Tundra (28-May) : Cooper stock=BUY BUY BUY
    Mucky Tundra (28-May) : Also notes he’s playing with more confidence.
    Mucky Tundra (28-May) : @AndyHermanNFL MLF says there was a time last year where Cooper was at 220 pounds. Now he’s at 240 and still flying around.
    Please sign in to use Fan Shout
    2025 Packers Schedule
    Sunday, Sep 7 @ 3:25 PM
    LIONS
    Thursday, Sep 11 @ 7:15 PM
    COMMANDERS
    Sunday, Sep 21 @ 12:00 PM
    Browns
    Sunday, Sep 28 @ 7:20 PM
    Cowboys
    Sunday, Oct 12 @ 3:25 PM
    BENGALS
    Sunday, Oct 19 @ 3:25 PM
    Cardinals
    Sunday, Oct 26 @ 7:20 PM
    Steelers
    Sunday, Nov 2 @ 12:00 PM
    PANTHERS
    Monday, Nov 10 @ 7:15 PM
    EAGLES
    Sunday, Nov 16 @ 12:00 PM
    Giants
    Sunday, Nov 23 @ 12:00 PM
    VIKINGS
    Thursday, Nov 27 @ 12:00 PM
    Lions
    Sunday, Dec 7 @ 12:00 PM
    BEARS
    Sunday, Dec 14 @ 3:25 PM
    Broncos
    Friday, Dec 19 @ 11:00 PM
    Bears
    Friday, Dec 26 @ 11:00 PM
    RAVENS
    Saturday, Jan 3 @ 11:00 PM
    Vikings
    Recent Topics
    1h / Green Bay Packers Talk / wpr

    3h / Green Bay Packers Talk / buckeyepackfan

    7-Jun / Green Bay Packers Talk / Mucky Tundra

    6-Jun / Green Bay Packers Talk / beast

    5-Jun / Green Bay Packers Talk / beast

    5-Jun / Green Bay Packers Talk / beast

    1-Jun / Green Bay Packers Talk / wpr

    29-May / Green Bay Packers Talk / Martha Careful

    27-May / Green Bay Packers Talk / Zero2Cool

    27-May / Random Babble / Martha Careful

    24-May / Green Bay Packers Talk / beast

    23-May / Green Bay Packers Talk / greengold

    23-May / Green Bay Packers Talk / earthquake

    22-May / Green Bay Packers Talk / beast

    22-May / Green Bay Packers Talk / bboystyle

    Headlines
    Copyright © 2006 - 2025 PackersHome.com™. All Rights Reserved.