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,
Like Grant, we also looked into this a few years back. We spoke to Tessitura consulting and several organisations that had tried to do something similar... the conclusion was that it was too risky and needed humans to double-check for incorrect matches.
We currently have our box office team do merging during down time which isn't a very exciting task but felt safer than relying on a stored procedure. But I'd be very interested to hear if you do get it working!