Irozenberg 1347 (3/1/2013)
Elementary sub-query or EXISTS clause wouldRadically improve performance.
If you like fancy coding you could pass XML as
parameter and use XQUERY.
Since you made a claim of performance, let's see your "elementary sub-query or EXISTS" clause.
I do agree that passing (ugh!) XML would also be fast but it has no respect for the "pipe".
--Jeff Moden
Change is inevitable... Change for the better is not.