I will ignore your comment about suggesting that always using NOLOCK is a good idea when integrity of the results is not important.:w00t:
To be clear (and to avoid being the guy who suggested someone use always use NOLOCK in any situation) I do want to point out that I included the caveat, "If NOLOCK is required..." I think my point would have been clearer if I said: If there is a requirement to use NOLOCK then use the always use WITH. That said, I can't think of a good reason to use NOLOCK and aver that a requirement that anyone must use NOLOCK is ridiculous. 😉
Edit: Just Louis' response; that is what I meant... Thank you sir.
-- Itzik Ben-Gan 2001