Original table design has 4 columns:
FCode (PK, nvarchar(50), not null)
ID (PK, uniqueidentifier, not null)
Allow (bit, not null)
ICode (nvarchar(50), not null)
The client has asked for a modification where we now need to use FCode and ICode and the primary key and not longer need the ID uniqueidentifier as they want to track this at a higher level than originally thought. The problem is, I'm assuming this table may have records already in it that will violate this new primary key.
Is there a way to re-insert as much data as possible from the original table, the data that doesn't exist the new primary key. I'm hoping to save as much existing data as I possibly can.