Sports Forum   |   Scoreboard   |   Contact Us   |   WinPicks Software   |   Talkstock   |   Advertise   |   Follow Us on Twitter   |   Register  |   Login 
Register to post in the sports forumDownload the ScoresLine App for Android 

 
 
Forums   Register   Profile   Inbox   Address Book   Subscribe   My Forums   Search   FAQ   Login   Log Out

Database Question   Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Pro Sports] >> MLB >> Database Question Page: [1]
Login
Message << Older Topic   Newer Topic >>
Database Question - 3/28/2019 7:27:21 AM   
bigtiger

 

Posts: 11474
Joined: 9/1/2008
From: Houston Texas
Status: online
Is there a way to query opening day? I know I can look up when opening day is each year and query the date, but that's tough to do because most years it has been done over multiple days, sometime a team is playing their 2nd game on "opening day" and so forth

Would like to see results from everyone's first game of the year and not finding an easy way

Any help appreciated
Post #: 1
RE: Database Question - 3/30/2019 5:09:02 PM   
Thomas


Posts: 30225
Joined: 9/2/2000
From: Canada
Status: online
How about this coach
game number=1

Want to see it by team

game number=1 and team, 1


want to see it by season
game number=1 and season, 1

team and season:
game number=1 and team, 1 and season


or for a different look


game number=1 and team, 1 and season,1

the ,1 is totals for team and/or season


Of course you know to sort just click the blue SDQL





< Message edited by Thomas -- 3/31/2019 5:09:36 PM >


_____________________________

Tom

(in reply to bigtiger)
Post #: 2
RE: Database Question - 3/30/2019 10:04:14 PM   
Thomas


Posts: 30225
Joined: 9/2/2000
From: Canada
Status: online
Damn Darryl after I reread your post I got to thinking all teams don't play opening day so that's probably not what you were looking for at all. I think that may be hard to do now that I think about it especially with those earlier games being played out of country. Hopefully John will have a peek in here, I don't call him the fabulous Gambrinus for no reason and if there's an answer to this he's our best bet





_____________________________

Tom

(in reply to Thomas)
Post #: 3
RE: Database Question - 3/30/2019 10:10:03 PM   
Thomas


Posts: 30225
Joined: 9/2/2000
From: Canada
Status: online
quote:

ORIGINAL: bigtiger



Would like to see results from everyone's first game of the year and not finding an easy way

Any help appreciated


More thought as I reread your post again, what I did leave you will give every teams first game of the season regardless of date


_____________________________

Tom

(in reply to bigtiger)
Post #: 4
RE: Database Question - 3/31/2019 10:40:24 AM   
bigtiger

 

Posts: 11474
Joined: 9/1/2008
From: Houston Texas
Status: online
quote:

ORIGINAL: Thomas

quote:

ORIGINAL: bigtiger



Would like to see results from everyone's first game of the year and not finding an easy way

Any help appreciated


More thought as I reread your post again, what I did leave you will give every teams first game of the season regardless of date



Yep, that is exactly what I was wanting. Thanks Tom!!!

(in reply to Thomas)
Post #: 5
RE: Database Question - 4/1/2019 7:53:49 PM   
Gambrinus


Posts: 1593
Joined: 4/1/2017
From: New Jersey
Status: offline
See that Thomas, you're quite the SDQL whiz yourself!

(in reply to bigtiger)
Post #: 6
Page:   [1]
All Forums >> [Pro Sports] >> MLB >> Database Question Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 Unicode

0.047