Home Forums SQL Server 2008 SQL Server 2008 - General Identify duplicate records where all fields, except one field, are the same. RE: Identify duplicate records where all fields, except one field, are the same.

  • December 22, 2010 at 1:58 pm

    #1265685

    Sean Lange (12/22/2010)

    try something like this.

    select item_num, pack, item_size, old_desc1, manufacturer_item_nbr, brand_name, opco_desc, flag, COUNT(distinct bid_price_old) as bidCount

    from #mx

    group by item_num, pack, item_size, old_desc1, manufacturer_item_nbr, brand_name, opco_desc, flag

    This is good the query returns several records with a count of 2 (duplicate bid prices) but..... I also need to be able to see the duplicate prices. It would be nice if i could return a field with both prices in one field like: $24.15 - $24.95. Is this possible???