Solved

SQL Server CONTAIN() Ranking

Posted on 2012-03-14
2
306 Views
Last Modified: 2012-06-27
Hi All,

I am using the following SQL which queries a View that has full text indexing enabled on a column call SearchContent.

I was under the impression that the records would be returned in rank order with the record with the most instances of the search term appearing at the top. But this doesn't seem to be the case.

Can anyone suggest what I could be doing wrong or provide alternative code to achieve this?

SELECT ProductName, ProductID
FROM ProductViewSearch
WHERE CONTAINS(SearchContent, 'tomy') AND 
ProductCatgeory IN(1,3,5)

Open in new window


Many thanks,

Rit
0
Comment
Question by:rito1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
ID: 37719698
0
 
LVL 1

Author Closing Comment

by:rito1
ID: 37722721
Brilliant thanks.
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
find SQL job run average duration 24 53
Copy data to New Year 9 29
Need SSIS project 2 23
SQL Syntax 6 27
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question