Home Forums SQL Server 2008 SQL Server Newbies How to delete duplicates/triplicates etc. except for the latest record based on date? RE: How to delete duplicates/triplicates etc. except for the latest record based on date?

  • June 13, 2013 at 9:00 am

    #1623756

    Hi Lynn,

    I get the following error when I parse your script:

    Msg 156, Level 15, State 1, Line 6

    Incorrect syntax near the keyword 'over'.

    I'm using SQL Server 2008 R2.