Is it possible to run a full text search on an FTS-indexed column for all values in another table?
Conceptually it'd look like
select d.* from Docs d, Tags t where CONTAINS(d.fulltext, t.tagvalue)
I'm rather new to MSSQL FTS, though I know that the equivalent would work in postgres
select d.* from docs d, tags t where to_tsquery(t.tagvalue) @@ to_tsvector(d.fulltext)
Thanks for the help!