Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-19 : 23:54:24
|
John Fuex writes "I am trying to merge results from a full text search engine with the results of a query on a SQL Server 7.0 database and have the following difficulty.
My FT search returns a list of ID numbers that correspond to a unique field in my database in a coma delimited string. This makes it easy for me to do a query as follows
SELECT * from MyTable where ID IN (String of coma delimited IDs goes here)
This has worked fine for some time now, but now that my app is evolving I would like to use some additional information returned by the full text engine. That is the relevancy ranking. For each DocID, my full text engine can also return an integer indicating how relevant that particular item is. The big issue is finding a way to select a field for this additional value and sort on it.
For example my external utility returns the following
ID Relevance
1 10
2 22
55 1
How can I then return a recordset based on MyTable that includes the Relevance information and sorts on it? (Preferably without temp tables. The result set can be many thousands of ID's and I am concerned about performance." |
|
|
|
|
|
Custom Sorting