I have a database where each entity has a unique ID, but recently all of the entity names were changed (not in the same way) to improve readability. This has made a lot of the summary reports look like the following:
ID Name Total for the year 3011 Joesmith 3000 3011 Joe Smith 1000 5024 DBS 400 5024 Deborah Smith 150
What's the best way of going about either correcting the old entries to match the new ones or simply displaying the new name for any matching ID? At the end of the day we can get the summaries we're interested in by just using the ID's, but ultimately we want to interpret those by seeing our names.
We're looking at about 1000 or so IDs with different names and maybe 50,000 or so rows in total.