I am new in SQL SERVER, working on SQL SERVER 2005 I have a requirement to do nth level fulltext search into result set of a fulltext query.
What is the requirement?
I have a textbox to get search keyword and a check box of SEARCH WITHIN RESULT or NEW SEARCH and a button of search.
User first search for a new query for KEYWORD1 and got a result set, then he check the SEARCH WITHIN RESULT and enter KEYWORD2 into textbox, he want to search into the result set of KEYWORD1 and get the second result set for KEYWORD2 that is actually a sub set of first result set, he want another SEARCH WITHIN RESULT for KEYWORD3 that would be the third result set and sub set of second result set of KEYWORD2. It would run until user has not enough record to search.
I write a query for that purpose but it just get result set for second level, for third and forth level it fails.
FROM MashupMetaInfo AS FT_MashupMetaInfo
INNER JOIN FREETEXTTABLE(MashupMetaInfo, *,
'FORMSOF (INFLECTIONAL,"New Mashup" )') AS KEY_TBL
ON FT_MashupMetaInfo.ID = KEY_TBL.[KEY]
AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video")')
ORDER BY KEY_TBL.RANK DESC
Can some Experts Help me