Post reply

Count the occurrence of word in a Resume Table

  • August 3, 2016 at 2:31 pm

    #328913

    I have a table called Resume with columns in Text, Word and PDF format. I enabled Full Text Search on the table and able to search the keyword through three columns and also able to rank the profile according to the keyword search .. Used below query snippet for the same:

    SELECT ct., ct.[RANK], br.ProfileID ,br.TextVersion, k.KeyWordName

    FROM CONTAINSTABLE( dbo.tblResumeTag, TextVersion , @SearchPhrase) as ct

    INNER JOIN dbo.tblResumeTag

    ON ct. = br.ID

    INNER JOIN dbo.tblKeywords k

    ON br.TextVersion LIKE '%' + k.KeyWordName + '%'

    AND k.KeyWordName LIKE '%' + @SearchPhrase + '%'

    ORDER BY ct.[RANK] DESC

    Now I want show the occurence(Count ) of the @search phrase in Textversion col, which I am struggling to return the exact count. Any suggestions will be helpful.

    Thank you

  • August 3, 2016 at 2:47 pm

    #1893621

    Please do not cross-post in future, it fragments responses and wastes people's time.

    Responses here please.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

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