Home Forums SQL Server 2012 SQL Server 2012 - T-SQL identifying many to many relationship between columns RE: identifying many to many relationship between columns

  • November 13, 2013 at 1:01 pm

    #1666197

    Can someone please help me to catch up? I feel I'm not understanding the issue. Using the OP's initial data:

    ITEM1 ITEM2 ID

    0224180 0224181 1

    0224180 0224190 1

    0224181 0224180 1

    0224181 0224190 1

    0224190 0224180 1

    0224190 0224181 1

    0202294 0202295 2

    0202295 0202294 2

    0209250 0209251 3

    0209251 0209250 3

    Why, for example, does the last value pair "0209251, 0209250" get an ID of 3? (This value pair appears only 2 times in the data.) Or why does the value pair "0224190, 0224181" get an ID of 1? (This value pair appears twice in the data.)

    Thanks, am hoping to grasp what's going on here so I can learn from it too! 🙂

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura