Soft Delete and Unique Constraint

When using the soft delete mechanism on the database, you might run into a situation where a record with a unique constraint was deleted and you want to reuse the unique value. If the unique value is…