Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a list of records contained within a MS SQL database table, we have enabled "Full Text Indexing" on the table. Also, we have set up Window's file indexing service and added a catalog containing *.doc, *.pdf, and *.xls files.

We have put the two pieces together by creating a search page that combines the results from the SQL Server database and the indexing service.

We are trying to determine how to use the "rank" passed back from both methods to order the results.

Here is an example of the query used to retrieve the rank for full text:

select rank 
from freetexttable(table1, description, @SearchText);

Here is an example of the query used to retrieve the rank from the file indexing service:

select rank 
from Scope() where freetext(contents, @SearchText);

Has anyone tackled this problem before? Is there a way to correlate the rank from both methods?


migration rejected from Jun 2 '15 at 8:54

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, Paul White, RolandoMySQLDBA, Mark Sinkinson, dezso Jun 2 '15 at 8:54

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Can you give us more details about how the file indexing thing works, and how it interacts with SQL Server? Your description is extremely vague. Also, which version of SQL Server are you using? – Jon Seigel Aug 14 '12 at 3:04