August 3, 2016 at 2:31 pm
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
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