Looking for a DB expert -Ping Arod or Garlon

ozziethesaint · 07-01-2006, 05:29 PM

Something I thought about just a few mins ago, that would benefit myself, Erich and Cubby. IS it possible to go through the DB and remove players with the exception of just their final seasons in the DB? my reason for asking is so that when creating current day roster sets we could go through and import players a year at a time and have all of the retired players with their final career stats, and then have correct hall of famers as well?

but if there's an easier way to accomplish this, please let me know. so that I can try it out and then share my sucess with Erich and Cubby

Thanks in advance to anyone that can help me out here

ozziethesaint · 07-01-2006, 10:07 PM

can anyone tell me if it's possible and if so how to delete players from the lahman database?

Ankit · 07-02-2006, 03:40 AM

It's doable but involves using some creative queries in Access or formulas in Excel. They need to be only a little creative and not at all complex. In Access, create a query that only pulls data for the year column is the MAX. Then export it and voila...

CBLCardinals · 07-03-2006, 08:32 PM

07-01-2006, 05:29 PM	#1 (permalink)
ozziethesaint Banned Join Date: Jul 2005 Location: Peoria IL Posts: 831	Looking for a DB expert -Ping Arod or Garlon Something I thought about just a few mins ago, that would benefit myself, Erich and Cubby. IS it possible to go through the DB and remove players with the exception of just their final seasons in the DB? my reason for asking is so that when creating current day roster sets we could go through and import players a year at a time and have all of the retired players with their final career stats, and then have correct hall of famers as well? but if there's an easier way to accomplish this, please let me know. so that I can try it out and then share my sucess with Erich and Cubby Thanks in advance to anyone that can help me out here

07-02-2006, 03:40 AM	#3 (permalink)
Ankit All Star Reserve Join Date: Feb 2002 Location: Philadelphia, PA, USA Posts: 569	It's doable but involves using some creative queries in Access or formulas in Excel. They need to be only a little creative and not at all complex. In Access, create a query that only pulls data for the year column is the MAX. Then export it and voila... __________________ Created the AnkitDB 5.2, AnkitDB 5.0, Career Average DB 5.0, Normalized Ankit DB 5.0, and Normalized Career Average DB 5.0.

07-03-2006, 08:32 PM	#4 (permalink)
CBLCardinals All Star Reserve Join Date: Feb 2002 Posts: 788	v Last edited by CBLCardinals : 07-03-2006 at 08:35 PM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

07-01-2006, 10:07 PM	#2 (permalink)
ozziethesaint Banned Join Date: Jul 2005 Location: Peoria IL Posts: 831	can anyone tell me if it's possible and if so how to delete players from the lahman database?