Updating multiple keys after de-dup
I have recently ran a de-duplication process and have a good set of cluster ID's. Within the application people / customers are given a unique number and this number should stay with them every time that they are entered into the database by people selecting them from a drop down list. Sadly however sometimes people don't find the person after a search and create a secondary, third or even fourth iteration - hense me de-duplicating.
What I want to be able to do however is retain one of the ID's that already exists however, either the first or last created.
So I had been thinking about assessing which record was the oldest or newest, and I could potentially group all the cluster ID's together but i am having trouble working out how to get to where I want to be. In the example above cluster ID 1 should have their id's all overwritten to now be either 1 (oldest) or 24(newest).
Thanks again everyone.