SQL_Enthusiast (5/10/2013)
Sorry LynnMy COMMENT table (original table in DB) and TEMP_COMMENT are indentical in fields and data types. COMMENT has the FK on it while TEMP_COMMENT has no FK's or PK at all. It's built from an SSIS package that uses data from another system, transforms it, and places it TEMP_COMMENT where it waits for execution to be pushed into COMMENT...
I have attached a spreadsheet that has test data from my system, but in reality, it's identical to what TEMP_COMMENT will have in it after the SSIS packs loads it.
I don't see any foreign keys defined on TEMP_COMMENT.