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

  • Sean Lange (12/18/2013)


    From the sample output you posted you don't have any duplicates. There are unique values in one of those columns (I can't tell from the garbled display which one). What are the rules about deciding which row to return?

    I will be happy to help but you need to first help me. Take a few minutes and read the first article in my signature about best practices when posting questions.

    I think he was asking for duplicates based on inv_num.

    Igor Micev,My blog: www.igormicev.com