How can Full text Search provide count of phrases

• mkherdek

  Valued Member

  Points: 72

  More actions

  January 24, 2011 at 1:04 pm

  #233394

  Hi,

  I have implemented a stored procedure which would search a comma separated keywords using the Full Text Search and also show the count.

  I'm using sys.dm_fts_index_keywords_by_document view to retrieve occurence_count of each keyword. This works great as long as these keywords are single words.

  When I use the phrase; the search is performed great but I cannot retrieve the occurence_count of phrase using sys.dm_fts_index_keywords_by_document.

  Is there some other view or any other way; that I can retrieve the occurence count for the complete phrase?

  Thanks

• 456789psw

  SSCarpal Tunnel

  Points: 4728

  More actions

  January 24, 2011 at 2:35 pm

  #1277480

  on second thought it wont work....

  only thing you might try is the ranking function