SQL> @sql\scorerep Enter value for date: 09-JUL-2001 old 11: where r.weekof = '&&DATE' new 11: where r.weekof = '09-JUL-2001' old 23: where r.weekof = '&&DATE' new 23: where r.weekof = '09-JUL-2001' MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Chris C DMiller ARI -3 -1 -3 1 1B PKonerko CHA -4 6 -4 0 2B QVeras ATL -1 4 2 3B SRolen PHI -4 9 3 3 3 SS OVizquel CLE -5 0 2 0 4 OF1 GKapler TEX 4 -1 5 0 OF2 LBerkman HOU 0 -1 4 -1 OF3 JGonzalez CLE 8 -4 13 9 DH EMartinez SEA -1 4 2 1 5 B1 BSantiago SFN -1 -4 -3 0 B2 DDeShields CHN 1 -2 3 4 B3 LAlicea KCA -1 7 5 B4 MMora BAL 4 -2 -2 2 B5 CPatterson CHN 0 -1 -1 -3 SP1 GMaddux ATL 2:S SP2 CDurbin KCA 18:S SP3 WMiller HOU -25:S SP4 KTapani CHN SP5 DNeagle COL SW1 BJJones SDN -4:S SW2 JHamilton TOR 11:S SW3 SHitchcock SDN RP1 MRivera NYA 9:R RP2 UUrbina MON -5:R RP3 TPercival ANA 4:R -14:R IR CPena TEX IR JCrede CHA IR MLieberthal PHI IR MRedman MIN IR PrWilson FLO IR TMcKnight HOU MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Eric C SHatteberg BOS 5 1 -1 1B JVanderWal PIT 1 2 -2 0 3,1 2B RDurham CHA -1 -2 6 3 2 3B CKoskie MIN 21 -1 4 -1 5,1 SS MDeRosa ATL 5 0 0 3 4 OF1 MLawton MIN -1 -4 -1 -4 6 OF2 ShStewart TOR -1 1 -1 -1 OF3 BTrammell SDN 3 -1 2 3 DH JCanseco CHA -1 4 B1 JConine BAL -2 -3 0 0 B2 JOfferman BOS -4 1 -4 -1 B3 MGrace ARI -4 10 -1 1 B4 A1Gonzalez TOR -5 0 6 -1 B5 MLoretta MIL -2 6 -1 0 B6 ARios SFN 0 7 SP1 MMulder OAK 36:S SP2 NFigueroa PHI -18:S SP3 RBell TEX SP4 TMattes MON -23:S SP5 APettitte NYA -6:S SW1 EGagne LAN SW2 AFultz SFN 4:R 2:R RP1 JIsringhause OAK 10:R 7:R RP2 MiWilliams PIT 6:R RP3 KSasaki SEA 5:R 7:R IR CPavano MON IR DBrown KCA IR DDreifort LAN IR JarWright CLE MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Joe C CKreuter LAN 0 -3 1 1B RSexson MIL 6 9 -2 10 3 2B PReese CIN 2 2 0 5 2 3B TGlaus ANA 0 -1 0 -1 2 SS NPerez COL -4 -2 -2 3 5 OF1 ShGreen LAN -1 10 -7 11 3,4,2 OF2 KGriffeyJr CIN -1 1 -1 8 OF3 JPierre COL -1 -4 15 -4 DH TClark DET 11 1 -1 1 3,4,2,5,1 B1 RCasanova MIL -1 -1 -1 -4 B2 CStynes BOS -1 -4 -4 20 B3 DBichette BOS -1 -3 B4 GAnderson ANA 3 4 2 -1 B5 OCabrera MON 0 -2 1 0 SP1 CPark LAN -35:S SP2 DWells CHA SP3 LHernandez SFN -9:S SP4 FCastillo BOS SP5 SSchoeneweis ANA 25:S SW1 CHolt DET -21:S SW2 SParris TOR 12:S SW3 SHasegawa ANA 4:R RP1 JRocker CLE -7:R RP2 RNen SFN 2:R 8:R 4:R RP3 BKoch TOR -1:R 5:R IR BMolina ANA 5 -1 4 -3 IR DHenson NYA IR KBenson PIT MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- John C BPetrick COL -1 5 -4 4 1B RPalmeiro TEX 1 8 0 -3 1 2B BBoone SEA 4 -1 3 4 3B DaBell SEA 10 2 -4 6 3 SS JWilson PIT -1 2 -4 -2 3 OF1 SSosa CHN -3 9 -2 -2 1,2 OF2 CLee CHA -4 3 7 0 OF3 BJordan ATL 1 -4 6 0 DH BSurhoff ATL 4 6 -1 -4 1,2,4 B1 KMillar FLO 10 4 9 8 B2 RLankford SLN 3 1 6 4 B3 JoseValentin CHA 0 11 0 B4 DWilson SEA -3 -1 -4 SP1 BColon CLE 23:S SP2 RClemens NYA 1:S SP3 FGarcia SEA 19:S SP4 CCarpenter TOR 26:S SP5 KAppier NYN 7:S SW1 CMichalak TOR -22:S SW2 JTowers BAL -18:S SW3 MHerges LAN -10:R 7:R SW4 JosCabrera ATL 3:R RP1 BWickman CLE 3:R 4:R RP2 BPrinz ARI 6:R RP3 TPhelps TBA 4:R 1:R IR BMoehler DET IR CTruby HOU IR MaWilliams ARI 0 -4 9 IR RSanders ARI -3 -4 -2 IR RVelarde TEX 2 4 MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Keith C RFick DET 8 -4 14 1B SCasey CIN -4 -4 1 1 2B EAlfonzo NYN 6 -2 -1 1 2 3B RVentura NYN 4 1 -4 3 SS JRollins PHI -3 5 2 3 2 OF1 THunter MIN 14 0 -4 -3 1 OF2 JPayton NYN -4 -4 0 -4 OF3 BAbreu PHI 0 2 4 1 DH DSegui BAL 4 -4 -1 3,1,2 B1 JGibbons BAL 8 0 -2 B2 JLugo HOU 0 -1 7 -2 B3 AHuff TBA 7 -3 0 SP1 RHalladay TOR SP2 PAbbott SEA -2:S SP3 MClement FLO 20:S SP4 DWilliams PIT -7:S SP5 KWells CHA 7:S SW1 ALopez TBA 18:S SW2 RRupe TBA SW3 TLilly NYA -24:S SW4 JPineiro SEA 10:R SW5 MatAnderson DET 2:R 7:R RP1 BWagner HOU 4:R 6:R RP2 JZimmerman TEX 8:R RP3 ARhodes SEA 9:R 1:R IR AEscobar NYN IR BLawrence SDN IR CEverett BOS IR DStark SEA IR FThomas CHA IR JHouse PIT IR MLeCroy MIN IR PMartinez BOS IR PRigdon MIL MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Marcu C PLoDuca LAN -2 -1 8 -4 1 1B BDaubach BOS -3 -2 8 2 2B JBell ARI -1 3 8 -3 2 3B PNevin SDN -3 6 3 4 3 SS SHalter DET -3 -2 4 4 5 OF1 CSingleton CHA 4 -1 4 1 4 OF2 JDye KCA -1 -3 4 -4 OF3 JEdmonds SLN -2 0 0 0 DH BFullmer TOR 2 3,4,5,2 B1 DFletcher TOR -1 -2 1 B2 SSpiezio ANA 0 10 3 -1 B3 JRanda KCA -3 -3 -3 -1 B4 DMartinez ATL -1 -1 -2 -1 B5 TWomack ARI 0 4 5 -3 SP1 MMussina NYA -47:S SP2 CSmith FLO 21:S SP3 MGardner SFN SP4 RuOrtiz SFN 16:S SP5 CLidle OAK 9:S SW1 FRodriguez SFN 3:R 3:R SW2 DHermanson SLN 21:S SW3 RWolf PHI RP1 THoffman SDN 7:R 4:R RP2 RoHernandez KCA 8:R RP3 SKarsay ATL 4:R IR DJustice NYA IR JDAmico MIL IR JHammonds MIL IR PHarnisch CIN IR VWells TOR MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- MichJ C EDiaz CLE -4 -4 -4 1 1B JaGiambi OAK -4 16 7 9 2 2B AKennedy ANA -4 -4 -1 3 3 3B EChavez OAK 0 4 2 5 SS MTejada OAK 7 2 -4 0 3 OF1 BWilliams NYA -4 -1 4 1 4 OF2 CFloyd FLO 4 10 3 6 OF3 MAlou HOU -1 0 4 8 DH MOrdonez CHA -2 2 -4 -4 4,2,5,1,3 B1 JKendall PIT -2 0 -2 2 B2 TMartinez NYA 0 -4 -2 -5 B3 DEckstein ANA -2 -4 0 -1 B4 AJones ATL 4 3 -4 -4 B5 CRipkenJr BAL -1 3 15 -2 SP1 EMilton MIN 15:S SP2 OPerez ATL -31:S SP3 DCone BOS 21:S SP4 CReitsma CIN -30:S SP5 ROswalt HOU 18:S SW1 ODaal PHI 19:S SW2 DReichert KCA SW3 TWakefield BOS -3:S RP1 BKim ARI 4:R 5:R RP2 GLloyd MON 3:R RP3 KLigtenberg ATL 3:R 3:R IR BChen PHI IR JOrtiz OAK IR RDavis SFN MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- MichR C SWooten ANA 3 2 2 -3 1 1B MSweeney KCA -1 -3 -1 -2 2B FVina SLN 1 2 -4 7 2,3 3B MLowell FLO 6 2 -1 10 3 SS CGuzman MIN 0 3 OF1 TNixon BOS -1 1 -1 -1 4,5 OF2 MKotsay SDN 11 -1 7 -1 OF3 MCameron SEA 1 -4 -2 7 DH CIzturis TOR -4 0 5 2,5,4,3 B1 JLaRue CIN 3 -1 1 3 B2 LRivas MIN 0 -1 7 -3 B3 PPolanco SLN -4 -1 -4 6 B4 MCordova CLE 2 -4 -2 -1 B5 APujols SLN -1 -1 6 5 SP1 TGlavine ATL 24:S SP2 BZito OAK 14:S SP3 HNomo BOS -5:S SP4 GRusch NYN 44:S SP5 AnBenes SLN SW1 JSantana MIN SW2 EHiljus OAK 1:R SW3 JMarquis ATL RP1 RBeck BOS 3:R 3:R RP2 PShuey CLE 4:R -6:R RP3 RFranklin SEA 4:R IR CDuncan CHN IR CFinley CLE IR DOrtiz MIN IR JRomero MIN IR MKinney MIN IR TSalmon ANA MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Nate C JLopez ATL 1 0 -4 -1 1 1B JThome CLE 13 2 -4 2 2 2B RAlomar CLE 1 6 3 -1 3B ABeltre LAN 4 -3 3 -1 3 SS ARodriguez TEX 1 6 2 14 OF1 RHidalgo HOU 0 5 4 -3 OF2 AOchoa CIN -2 -1 -1 5 OF3 VGuerrero MON -2 11 9 0 DH ASoriano NYA -1 3 -1 4 4 B1 BAusmus HOU 9 -2 3 B2 PBurrell PHI -4 3 -4 7 B3 GBlum MON -3 6 0 B4 RGreer TEX SP1 ABurnett FLO 14:S SP2 AEaton SDN SP3 RPerson PHI 0:S SP4 TArmasJr MON 20:S SP5 THudson OAK 6:S SW1 CSabathia CLE 25:S SW2 JKennedy TBA -16:S SW3 LProkopec LAN 16:S SW4 BuSmith SLN RP1 ABenitez NYN 4:R 7:R RP2 JWitasick NYA -21:R RP3 FGordon CHN 3:R 6:R 5:R IR APerez SEA IR APiatt OAK IR BMueller CHN IR JBeckett FLO IR JRauch CHA IR NJohnson NYA MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Phil C IRodriguez TEX 10 -4 -1 1 1B THelton COL 1 0 2 2B TWalker COL -1 11 -1 3B ARamirez PIT -4 0 4 1 1 SS RGutierrez CHN 14 2 -1 -3 3 OF1 MDarr SDN 2 -1 -4 2 4,2 OF2 GJenkins MIL 6 9 -4 2 OF3 BGiles PIT -2 1 4 1 DH GSheffield LAN -1 2 -1 0 4,2,3,1 B1 MBarrett MON -2 2 1 -4 B2 DYoung CIN -2 -4 5 3 B3 RClayton CHA -3 0 0 3 B4 MGrissom LAN -4 -2 -2 SP1 JMays MIN -27:S SP2 RDempster FLO -2:S SP3 RaOrtiz ANA -12:S SP4 MMorris SLN 25:S SP5 JBurkett ATL -1:S SW1 SKline SLN 4:R 4:R SW2 TRedding HOU 1:S SW3 TRitchie PIT 46:S SW4 REllis ARI -6:S RP1 DVeres SLN 2:R -6:R RP2 TWorrell SFN RP3 JMesa PHI 1:R 6:R 1:R IR AAshby LAN IR BTollberg SDN IR CLoewer SDN IR JDrew SLN IR JGrilli FLO IR JSmoltz ATL IR JoshHamilton TBA IR NGarciaparra BOS IR RAnkiel SLN IR THollandswor COL IR WSerrano SDN MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Rao C APierzynski MIN 1 4 -2 0 1 1B JOlerud SEA -5 10 -2 9 2B DEasley DET -5 0 -1 -1 3B VCastilla HOU -4 18 -1 2 2 SS RSanchez KCA -1 -3 3 -4 3 OF1 GVaughn TBA -1 5 1 OF2 BHigginson DET 11 9 -2 9 OF3 LWalker COL -1 -4 9 6 DH FMcGriff TBA -2 5 -1 18 4 B1 HBlanco MIL -3 B2 RCoomer CHN 0 -1 -2 3 B3 DJackson SDN 1 -4 9 1 B4 JEncarnacion DET -1 -4 -3 -4 SP1 KWood CHN 4:S SP2 CSchilling ARI 19:S SP3 JLieber CHN 11:S SP4 SPonson BAL -15:S SP5 STrachsel NYN SW1 JBere CHN 15:S SW2 SElarton HOU SW3 SReed ATL -1:R SW4 JBaldwin CHA RP1 CLeskanic MIL 4:R -2:R 4:R RP2 JNelson SEA 2:R RP3 MRemlinger ATL 3:R 4:R IR AReynoso ARI IR BLarkin CIN IR CEldred CHA IR JVaritek BOS IR JohnValentin BOS IR KCaminiti ATL 11 -3 -1 -2 IR OHernandez NYA MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Rick C CJohnson FLO 4 -2 8 1 1B CDelgado TOR 3 -1 4 -1 4 2B JVidro MON -1 10 13 9 5 3B JCirillo COL 0 -2 3 -2 2 SS REMartinez SFN 3 10 -3 3 3 OF1 MRamirez BOS -4 4 -3 2 3,5 OF2 EBurks CLE 8 7 -4 OF3 RoWhite CHN 2 -1 DH RKlesko SDN 4 7 -2 -2 3,4 B1 THundley CHN B2 CGuillen SEA -2 3 4 -1 B3 RBranyan CLE -1 1 B4 EDurazo ARI 1 0 B5 FCatalanotto TEX 2 -1 4 SP1 BRadke MIN -10:S SP2 MHampton COL -36:S SP3 ALeiter NYN 21:S SP4 JWeaver DET 12:S SP5 BriAnderson ARI 13:S SW1 JSuppan KCA 8:S SW2 LHawkins MIN 6:R SW3 JTavarez CHN 2:S RP1 DLowe BOS -1:R 3:R RP2 JMecir OAK -17:R 7:R RP3 JPaniagua SEA 3:R IR DCruz DET IR IValdes ANA IR PCrawford BOS MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Steve C MPiazza NYN 3 6 1 13 1B DMientkiewic MIN 3 -1 1 1 1 2B EYoung CHN 5 4 -1 3 3B SBrosius NYA -2 5 1 -2 3 SS BRoberts BAL 1 -4 -1 -1 2 OF1 PONeill NYA 0 5 7 -1 OF2 BBonds SFN 6 -1 -4 -2 OF3 ISuzuki SEA -1 -3 4 -5 DH RMondesi TOR -1 -4 -1 5 3,2,1 B1 CRichard BAL 3 2 0 B2 ANunez PIT -1 -3 -1 B3 TBatista BAL 0 0 7 -3 SP1 RaJohnson ARI 0:S SP2 JaJohnson BAL -3:S SP3 ASele SEA 42:S SP4 RHelling TEX 25:S SP5 JamWright MIL 17:S SW1 JMoyer SEA -16:S SW2 GHeredia OAK SW3 JMercedes BAL SW4 WRoberts BAL 17:S SW5 TWendell NYN 3:R 0:R RP1 MTrombley BAL 2:R 4:R RP2 AAlfonseca FLO 0:R -8:R RP3 JShaw LAN -4:R 3:R IR MBordick BAL IR PMeares PIT MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Subra C BDavis SDN 2 -1 0 1B MMcGwire SLN 10 -4 6 4 5 2B JKent SFN -2 -1 -1 9 1 3B TFryman CLE 4 4 -5 3 SS DJimenez SDN 6 -1 1 3 2 OF1 JDamon OAK 6 1 -2 0 4,5 OF2 JBurnitz MIL -4 -4 -4 OF3 KLofton CLE 4 3 -7 0 DH DLee FLO 4 -4 -2 -4 4,1,2,5,3 B1 LCastillo FLO 5 10 0 -1 B2 ERenteria SLN 3 -2 -1 B3 ABoone CIN 2 -4 0 7 B4 BAgbayani NYN -3 3 B5 TLee PHI -4 1 -4 4 SP1 PAstacio COL -18:S SP2 SEstes SFN -8:S SP3 KRueter SFN 1:S SP4 JWashburn ANA -6:S SP5 BSheets MIL 5:S SW1 MStanton NYA 5:R 1:R SW2 KJarvis SDN -14:S SW3 JWestbrook CLE -13:S RP1 DGraves CIN 3:R 7:R RP2 JJimenez COL RP3 KFarnsworth CHN 2:R 1:R IR ABoone CIN 2 -4 0 7 IR DPalmer DET IR EYan TBA 0 IR JGerut COL IR JHalama SEA IR RAnderson SEA IR RFurcal ATL IR VSantos DET MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Tim C THouston MIL -1 -3 1 1B JBagwell HOU 9 17 -5 1 2B CBiggio HOU 3 6 1 6 2 3B JHernandez MIL -3 1 -1 4 SS RAurilia SFN 4 -3 4 -1 3 OF1 MTucker CIN 1 -1 -2 -5 OF2 BGrieve TBA 5 0 3 OF3 CBeltran KCA -3 -3 12 5 DH MQuinn KCA -1 -3 6 -4 B1 RaHernandez OAK 11 6 1 B2 CKnoblauch NYA 2 4 4 B3 MMcLemore SEA 0 -4 -1 4 B4 HPerry CHA -1 -1 -4 SP1 MBuehrle CHA 19:S SP2 JVazquez MON 28:S SP3 TOhka BOS SP4 BPenny FLO SP5 SReynolds HOU -43:S SW1 ALevrault MIL 2:S SW2 SSparks DET 30:S SW3 RArrojo BOS 11:S SW4 KLohse MIN 5:S RP1 KFoulke CHA 4:R 6:R 6:R RP2 BHowry CHA -6:R 4:R RP3 CZerbe SFN -2:R IR FTatis MON IR HChoi CHN IR KMillwood ATL IR PHentgen BAL IR RMateo CIN IR SBurroughs SDN MGR POS NAME TEA MON TUE WED THU FRI SAT SUN OTHER ----- --- ------------ --- ----- ----- ----- ----- ----- ----- ----- --------- Vasu C JPosada NYA -1 1 0 0 1 1B EKarros LAN 0 1 -2 1 2 2B MGrudzielane LAN -4 7 -3 3,5 3B CJones ATL 4 1 -4 -3 5 SS DJeter NYA 3 -4 6 9 OF1 DGlanville PHI -1 0 4 5 4,2 OF2 JoCruz TOR 5 2 -5 1 OF3 LGonzalez ARI -1 14 2 -4 DH RSierra TEX -4 4 1 3 3,1,2,4 B1 JEstrada PHI 0 -1 -4 B2 MStairs CHN -1 -4 -1 -3 B3 FMenechino OAK 0 -4 2 1 B4 DErstad ANA -3 -1 1 4 B5 JMacias DET 2 7 -1 4 SP1 KBrown LAN 15:S SP2 DKile SLN -10:S SP3 RReed NYN 20:S SP4 WWilliams SDN -36:S SP5 JAnderson PIT 28:S SW1 PRapp ANA SW2 RBiddle CHA 12:S SW3 EDessens CIN -7:S RP1 JFassero CHN 10:R 1:R 4:R RP2 PQuantrill TOR 4:R -6:R RP3 MVenafro TEX 3:R 4:R IR MMantei ARI IR RBottalico PHI 486 rows selected. SQL> spool off