1. DELETE
  2. FROM     #banData
  3. WHERE    EXISTS    (
  4.          SELECT    BAN
  5.          FROM    #banData b
  6.         WHERE    b.BAN = #banData.BAN AND
  7.             b.Row_ID < #banData.Row_ID
  8.          )