Today I'm going to work with Fuzzy Logic.
What that does is looks for matches of data based on a threshold.
So you can specify what percentage is an acceptable match.
I've done this before on a contract through Bloom Consulting, where the logic resided within an SSIS component.
However, today I'll be working with the Fuzzy Logic within T-SQL function is called Jaro-Winkler.
The goal is to find similar matches of data, so we can plug some missing values in some tables.
And by doing that we will essentially close the loop on some otherwise disperate data sources.
Wish me lucK, I'm going in!