deleting duplicate rows based on a condition

SQLServerCentral » Latest topics

deleting duplicate rows based on a condition

I've cobbled together other answers from similar posts but can't quite get over the finish line.
I'm trying to remove duplicate records. With the definition of "duplicate" being all fields except for one particular field.
The duplicate rows to del

more info...