Hello! Our organization is looking into developing a stored procedure to match and merge some of our duplicates automatically. Have any of you ever done this before, or do you know anyone who has? I'd love to hear what worked and what didn't, and find an existing procedure to base ours off of.
Hi Elise,
We looked into it years ago but found that a majority of the duplicate merges need a set of eyes to look over both records to determine which one to keep/delete. So the benefit of writing something to automate some of that would be minimal.
We use CSI's to allow duplicate merges to be managed by a variety of staff members in our box office so it ends up not being much work.