Getting A Single Per Column

I have the following table
Name Score Date

A 10 10/19
A 20 10/18
A 30 10/17
B 40 10/18
B 50 10/15
B 60 10/14


I need to get


Name Score Date


A 10 10/19
B 40 10/18


Basically I need one row per Name and that row has to be for the most recent date for
that Name


In Sql 2005 you could do this by


with MyCTE Name,Score,Date,Rownumber as
select Name,Score,Date,Row_Number() (over partition by Name order by Date desc) as Rownnumber
from Table A

Select * from MyCTE where Rownumber=1


Does anyone know how this can be achieved on sql 2000 as Row_number function is not in sql 2000


Thanks for any help in advance