Jason,

That works great. I've been fooling around with the thresholds to try and get the best match before I present it to the business. I also made a couple of other minot tweaks to handle the 'n/a' that can appear in any of the matching fields.

Takes about 12 minutes to run against our full table of 30k records.

One thing I got to thinking about is as we add more records to the dimMember table, and have to run this script against the table daily, member's groupId has the potential to change based on new/updated member data.

I'm curious as to your take on this aspect. I'm beginning to feel it's turtles all the way down.

I'm strongly advocating that the company get MDS in house so we can avoid this issue.