You original post states that you want to keep the row with the most recent date. Something like the SQL MAX statement might do the trick. What SQL server are you using?