Hmmm ... you and Fabio disagree on this one. I wonder who's right? =)
~~Bonnie
>>Yes, I know ... but the second example you gave seemed much simpler, so I went with it. <s> I don't know which one would be faster, but I don't have enough data to benchmark it right now.
>
>Hi Bonnie,
>
>I would expect the first one to be faster. The SQL Server is optimized for the first type of query because EXISTS subquery doesn't return any data.