Sorry about that extra re-post. I'm not even sure how that happened, as I surely wasn't trying to pester Sean into action. I'm happy whenever the info is...
Ok, after much hunting, here is how you can put multiple update statements into one file for execution. If I made a mistake somewhere, please let me know....
Simple question: how do you execute multiple SQL statements in Access? Right now, going through the Query/SQL view gives me only 1 SQL statement to execute....
Usually, I fall firmly in the camp of "more data." However, I don't really see the need for race in the database. It's true that it's subjective and often...
... It depends on who the 3-4 elite people are. If I were rating, and no "mixed" category were offered, it'd be difficult to get 80% agreement, as that's the...
Sean, I'm curious about your response to my question: ... I reviewed some sources and I can't find anyone (much less "all") claiming that the results of these...
Hi. I think this discussion of race has been interesting. But there is an obvious middle-ground. No, the racial definitions wouldn't be official, would be...
Guys, Rod Nelson from Denver here. As an introduction to the list, allow me to say what my current project is about for those I've not corresponded with ...
Greg sent this to me and labeled it the "ultimate Baseball Reference". I think I agree. I've annotated some of the entries. Players Major League Statistics ...
Take a sneak peak at Baseball2K2.NET, the online baseball game supporting multiplayer internet gaming. http://groups.yahoo.com/group/The_Online_Baseball_Game/...
I'm a newcomer to this group, but the last "digest" seems to indicate that there is a substantial effort going on to update the databases from baseball1.com to...
Hey guys. I have a huge favor to ask. I have created my own baseball message board, and I have no way of getting fans to visit and post messages. My site is...
Some miscellaneous problems I found while loading the 2001 update into a copy of the existing Access 97 database. Although largely trivial, such things tend...
Folks, I'm glad to see more and more people on board here. The number of posts has dwindled somewhat in the last few weeks, but I want to assure everyone that...
Hi, I just joined the data-bank group. My name is Dan Holmes and I work at the Hall of Fame. Some of you may have been to my website - www.thebaseballpage.com...
... A simpler solution would be to change the "Innings Pitched" field to "Outs Pitched", which would never require fractions or decimals, can easily be added...
IMHO, this issue is far simpler than one would surmise from the amount of attention it has inspired. Point 1. In the existing database, the IP field in the...
Warning: Long post! Some changes I'd like to see made to the Lahman DB. And also a bunch of questions, suggestions, etc. Take it for what it's worth. 1. I'd...
In the 2001 Fielding table, the columns under the headings G PO A E DP GS INN appear to contain G TC PO A E GS INN It's wonderful to have the GS and INN data....
I was able to implement franchise continuity by adding one new column to the TeamMaster table. Following are the necessary SQL statements, and a sample query...
... Here's a quote from the 2001 TSN Guide which accompanies the AL team pitching statistics. "NOTE-Totals for earned runs for several clubs do not agree with...
I checked to see if the totals of fields in the Batting and Pitching tables, grouped by team, matched the values in the Teams table. Other than shutouts, they...
For pitchers, the pattern seems to be that the Batting.G column shows the number of non-DH games in which the pitcher played, except for pitchers who did not...
Zounds: Update Master set Lastname="Wilson" where Lastname="A. Wilson"; For consistency with all the other players known by their initials: Update Master set...
I realize it's outside the scope of what you've done, Sean, but what about non-active players who have died? The SABR biographical committee can provide an...
