Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Duplicates

    This seems simpler to me:

    DELETE --or SELECT *

    FROM #DuplicateRow

    WHERE JobTitle = 'Editor' and datemodified < (SELECT MAX(datemodified) FROM #DuplicateRow WHERE JobTitle = 'Editor')

Viewing post 1 (of 2 total)