Re: full text search on multiple tables yielding one rank

Without consolidating all of your data in the multiple tables into a child
table there is no way to do this with a meaningful rank.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"surigaonon" <surigaonon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28625427-A482-40B3-991B-BC7C35501801@xxxxxxxxxxxxxxxx
> Is it possible to do full text search on multiple tables and having one
> rank
> for all searches? Ive read a lot of articles that gives me code samples on
> doing FTS on multi tables but they gave me multiple ranks for each search.


.

Relevant Pages

  • Re: Multiple State and product based analysis project
    ... orders over multiple states (one, none or multiple orders per state are all ... I can determine the 90% rank of the entire list as follows: ... product and state variables. ... If your simple data file only have two columns, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Multiple State and product based analysis project
    ... orders over multiple states (one, none or multiple orders per state are all ... I can determine the 90% rank of the entire list as follows: ... I have three product recaps that I create independent data columns for to ... product and state variables. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Survey Database Table Form Design
    ... I would use multiple questions as options for the multiple rank. ... values to more than 5 foods. ... I am very much under the gun as my own design seemed much less robust so I ...
    (microsoft.public.access.tablesdbdesign)
  • Re: containstable rank inconsistent
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... > then I get different rank results between identical searches (pre and post ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Ranking problem
    ... The ranking algorithim uses many factors to come up with a rank value, ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
Loading