I have an existing infrastructure that makes heavy use of Microsoft Indexing Service (you know, the obsolete one) and I have the need to perform a nested query, something a bit like this:
SELECT FileName
FROM (
SELECT All
FROM MMGT..Scope()
WHERE CONTAINS('"some text"')
)
WHERE DatePublished IS NOT NULL
Is this possible? I don't want to pull back vast amounts of data into my ASP .Net app to perform a secondary filter in a dataset, which currently seems like my only option.