Post reply

Using Full-Text to "match" rows in two different tables

  • December 8, 2011 at 3:10 pm

    #1418991

    Can you set up a sample table with a few rows of data? The link in my sig will show you how to do this.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • December 8, 2011 at 3:15 pm

    #1418995

    It's a big topic and will require some research, but look into 'fuzzy lookup' in SSIS.

    - Craig Farrell

    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

  • December 8, 2011 at 3:15 pm

    #1418996

    FTS is going to need the data to be on one table as well. you would have to have two searches then compare the rankings. That might work.

    I have always used FTS for more keyword search, but it doesnt mean it work for what you are trying to do.

    Is all this data in one col? just two tables.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply