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
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?