Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CraigMuckleston
Starting Member
6 Posts |
 Posted - 2009-08-18 : 03:59:50
|
| I am new to using Full Text Search. My query alwayse returns a rank value of 0. My query is below. I created a simple table with the columns (id, title, description)My Full Text Search is set up properly because I have queried it properly before, but now I want to use RANK in my results.I populated the table with a few rows, and used the following query: select r.[RANK],r.[KEY], t.* from tblTest t (nolock) inner join freetexttable ( tblTest, *, N'zeus apollo', 3 ) as r on r.[KEY] = t.intID order by r.[RANK] desc;When my results return, RANK is 0 on all rows. Any ideas where I;m going wrong? |
|
|
|
|
|
Using RANK in Fullt Text Search always returns 0