2. If there are duplicate records and they all have the same score, then remove all duplicates except one, preferably the one with the most data in the row.
If you post the schema for this table I can quickly give you a script to do this in SQL 2000. I used to write jobs that had to clean tables with no unique ID's. Should be easy to use a join and write a clean up script for the one you have.