• What are Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8? I don't mean the data types, but what are they? Are any of these columns a unique or primary key value for the data? This is information that would help in providing you with good answers.

    Technically, they are not unique or primary keys; I don't think they could be due to all the NULLs. No? But yes, logically, I guess we want that combination of the 8 columns to be unique within this table--but so long as NULL is considered equal to NULL. I'm not sure what else to say, they are just data. Apologies if I'm missing something.

    You also mentioned that there are other columns in the data that aren't used in the comparison. What is done with those values? Are they ignored, do they update their respective columns if the columns actually compared are updated in the Live table?

    The "other column" values may also change, and if so, yes we would like to insert those new values along with their respective records into Live.

    The end goal is that Live should have one record for every unique combination of the 8 "tracked" columns.

    Apologies again, sincerely, for the lack of DDL, I really didn't think it was pertinent in this case, but clearly I was wrong there.


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