• I believe that MS have stated that all hints will require the WITH statement in future to make it consistent.

    You shouldn't be using the WITH (NOLOCK) hint It can have some chaotic effects.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices