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 a 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 DB and the indexing service. What we are trying to figure out is 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.