I have a table with 10's of thousands of records each stamped with the user id from active directory, some bright spark has changed the user id's of 10 of the users in AD. So now there is no reference to the past work of those users. I have a xref table with the old and new id's for these users. How do I update the old user id in the main table with the new id only for users existing in the xref table?
I just can not get it to work.
Any suggestions welcome (even if I have to add a new column short term).