December 3, 2016 at 5:35 am
Hi there,
Is there a way of setting the Full text index to get the top 10,000 hits only?
I have created a Full text index on "html content of movie reviews page from different websites. I am looking for certain keywords and want only top 10,000 hits. How can I do that?
This is the code I have:
Declare @SearchTerm varchar(1000)
DECLARE Cur CURSOR LOCAL FAST_FORWARD FOR
SELECT SearchTerm
FROM dbo.MasterSearchTerms (nolock)
--example of Searchterm ISABOUT("kid friendly" weight(.1)) OR ISABOUT("rude humor" weight(.2))
OPEN Cur
FETCH NEXT FROM Cur INTO @SearchTerm
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT mvfti.RANK,mvfti.key,HTMLReviews
FROM [MovieReviews].dbo.Reviews
INNER JOIN
CONTAINSTABLE([MovieReviews].dbo.Reviews, HTMLReviews, @SearchTerm ,LANGUAGE N'English')) as mvfti
ON mvfti.=A.id
FETCH NEXT FROM cur INTO @SearchTerm
END
CLOSE Cur
DEALLOCATE Cur
Thanks
MR
December 4, 2016 at 4:33 am
closing this post myself as I figured out the answer.
If anybody has the same issue,
There is a parameter in CONTAINSTABLE that can be set.
CONTAINSTABLE([MovieReviews].dbo.Reviews, HTMLReviews, @SearchTerm ,LANGUAGE N'English',10000))
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy