>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.
--sb--