SQL Server更新外键指向一组重复项中的第一个

I have a mapping table with a foreign key column which points to a table of strings. In the string table, there are duplicates (which I plan to delete). Before I delete the duplicates, I want to update the mapping table so that each foreign key index points to the first instance of the string being pointed to.I have a mapping table with a foreign key colum