June 15, 2012 at 3:40 pm
Hi All-
I have two tables, each with a full text index on the provider_name field.
I have searched for hours for an example on if it is even possible to somehow use the full text functionality to return a result set that shows the provider_name from table 1 next to the closest matching provider_name from table 2. There are no ID fields linking the two tables, so I need to perform a match on the names.
I can get this to work for one provider name at a time, but ideally I want a full result set that has each provider_name from table 1 in the first column, and in the same row display the closest matching provider_name from table 2.
I get the feeling this isn't really meant to do this type of matching as there seems to be no mention of it anywhere.
If you know of a link to share that covers this type of matching, please share.
Thanks,
Paul
June 15, 2012 at 3:45 pm
This really doesn't work for Full-Text. Full-Text indexing's purpose really is single column use. However, you may want to investigate the Fuzzy Lookup component in SSIS. It, along with a little creative coding, will probably help you get where you need to be. However, in the end, you're going to be taking the value from one side and 'fuzzy lookup'ing' the other side in a loop of some kind, one way or another.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 18, 2012 at 3:40 am
You can do it with FT. But it may not be fast enough for you, it's really depends...
You will need to use CONTAINSTABLE to get the best match based on rank.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply