我正在对1000个文档进行语义分析。我想为每个文件的前5个匹配。下面是我正在使用的查询;
DECLARE @FTE hierarchyid
SELECT @FTE = path_locator
from dbo.LatinBooks
Select top (5)
e.name
,d.name as MatchedFTE
,KEY_TBL.score
FROM SEMANTICSIMILARITYTABLE
(dbo.LatinBooks,
file_stream,
@FTE ) as KEY_TBL
INNER JOIN dbo.LatinBooks d on KEY_TBL.matched_document_key= d.path_locator
left Join (select path_locator,name from dbo.LatinBooks) e on @fte=e.path_locator
Order by Key_tbl.score DESC;
此查询有效,它返回第一个文档的最匹配的文档。我可以对脚本做哪些更改,使其返回所有1000个文档的匹配。结果将显示5000行(1个Doc和5个匹配项)
https://stackoverflow.com/questions/38132395
复制相似问题