views:

3

answers:

0

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.