Discuss Stuck on something that seems quite simple in the MS SQL Development forum on Dev Shed. Stuck on something that seems quite simple MS SQL Development forum discussing administration, MS SQL queries, and other MS SQL-related topics. SQL Server is Microsoft's enterprise database engine.
Time spent in forums: 37 m 31 sec
Reputation Power: 0
Stuck on something that seems quite simple
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).