I know, I know... but I can't post the actual query due to business issues... and well... I REALLY don't want to rewrite the whole thing as an...
I wrote a query using a correlated subquery and it takes 5.78 seconds PER RECORD to return results. The SAME query, only I select the "outer" query...
Separate names with a comma.