Problem with Ranking

Hi All,

I have a problem with the ranking in my query.. maybe i didn't
understand well how it works.
Here is my questions :
I have 4 items : I added the string "159357" to each one:
00006 in Title
00004 in Resolution Description
00002 in Description
00005 in Resolution Title


I send this query :

SELECT "DAV:href",
"urn:schemas.microsoft.com:fulltextqueryinfo:rank"
FROM (TABLE Solution_Index..SCOPE() UNION ALL TABLE
Non_Portal_Content..SCOPE() )
WHERE WITH
("urn:schemas.microsoft.com:htmlinfo:metainfo:DC.TITLE":0.4,
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.RESOLUTIONDESCRIPTION":0.3
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.SOLUTIONDESCRIPTION":0.2,
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.RESOLUTIONTITLE":0.1,
)AS #WeightedProps
(FREETEXT
(#WeightedProps, '159357')
AND
("urn:schemas.microsoft.com:fulltextqueryinfo:Sourcegroup"
= 'OneCRMSolutionsContent'
))
ORDER BY "urn:schemas.microsoft.com:fulltextqueryinfo:rank" DESC

After Index I send query the search result should be in order: 6 ,4,2,5
And i get the items in this 4,6,2,5....

Do you know why? did i miss something?

Thanks for the help
Estelle

.

Relevant Pages

  • Re: DNS is slow
    ... This is the wrong query because it will first query for ... DNS cache on the client before the second query? ... Do you want to say that "name resolution via Internet Explorer is ... Wireshark is the way to go. ...
    (microsoft.public.windows.server.dns)
  • simple SQL query problem...
    ... I could do with a little help on a sql query. ... browser and resolution they are using. ... can't seem to get it to work with the distinct keyword or group by. ...
    (microsoft.public.sqlserver.programming)
  • Re: Simple program cwitching thru all video-modes craps-out ...
    ... is no standard graphics-bios command for that. ... Use VESA mode query commands to determine modes and capabilities ... change when I select another resolution ...
    (comp.lang.asm.x86)
  • Re: Problem with Ranking
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... I have a problem with the ranking in my query.. ... 00004 in Resolution Description ...
    (microsoft.public.inetserver.indexserver)
  • Re: simple SQL query problem...
    ... > SELECT TOP 100 PERCENT resolution, COUNT(DISTINCT ipaddress) AS ... >> I could do with a little help on a sql query. ... >> Chris Dangerfield ...
    (microsoft.public.sqlserver.programming)
Loading