Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Tue, 25 Mar 2008 10:50:55 -0700 (PDT),    group: microsoft.public.sqlserver.fulltext        back       


ranking by most words found first? ISABOUT/WEIGHT/RANK?   
This code does not appear to care that we have rows with both words vs
only one word...


select * from COLLABORATOR x inner join
containstable
(Collaborator,*,
' ISABOUT (
"hiv" weight (.5)
or
"gender" weight (.5)
)
'
)
as KEY_TBL
on x.ColId = KEY_TBL.[KEY]
order by rank desc

How can I make query weigh rows with both words higher, then followed
by frequency of occurrances of either word.

Thanks in advance for any help or information.
date: Tue, 25 Mar 2008 10:50:55 -0700 (PDT)   author:   unknown

RE: ranking by most words found first? ISABOUT/WEIGHT/RANK?   
We have the same problem here, but we've been unable to find a solution to 
this either...
I came here actually to ask the same thing when I realized no one has 
answered this post yet.

Anybody found anything?
date: Sun, 13 Apr 2008 00:53:00 -0700   author:   Ehsan

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us