Home Forums SQL Server 2008 SQL Server 2008 - General Delete duplicate row based on one column, but need to retain rest of the values in tmp file RE: Delete duplicate row based on one column, but need to retain rest of the values in tmp file

  • December 18, 2013 at 8:04 am

    #1674446

    Gillian_Pappas2002 (12/18/2013)

    Thank you so much. That worked really well, but for some reason, there remain a few randon duplicate co_nums rows showing up. But I truly appreciate your help. Thanks. G

    You have to identify what is unique in your data and/or and what columns to use in order to determine rows for deleting.

    Igor Micev,My blog: www.igormicev.com