Home Forums SQL Server 2005 T-SQL (SS2K5) find out which record_ids match on 2 fields and not match a third field. RE: find out which record_ids match on 2 fields and not match a third field.

  • February 13, 2008 at 1:28 pm

    #778060

    The Temp table is for example and does represent a table created from joining 2 other tables.

    When the 2 other tables are joined, I get multiple rows for some of the record_Ids.

    For Each one of the multiple rows, I need to assign a status.

    status is determined by how many field match across the multiple rows for same record_id.

    Thanks,

    Ben