I agree. The simplest way to deduplicate is using grouping and aggregate functions as needed.

regards

Áron

Hello,

I think the example is not the luckiest as once you have a stored proc that deletes the record it could take care of the auditing part as well.

Adding auditing...