Our delivery people have added recipients with no standard format over time. We have many rows with duplicate employee ID's and I'd like to clean this table up, but I understand the associated recipient ID is also used in the DELIVERY_EVENT table, so there's the issue of violating referential integrity. Has anyone attempted to maintain the RECIPIENT table, and if so, would you share how you went about doing so?
Thanks in advance!