• david.wright-948385 (2/12/2014)


    sknox (2/12/2014)


    ...This can be alleviated by formatting, e.g:

    WHERE

    (

    (a = b)

    OR

    (b = c)

    )

    AND

    ...

    as opposed to

    WHERE ((a = b) OR (b = c)) AND ((c = d) OR ((d = e) AND (e = f)))

    Exactly. IMHO, this goes for general query layout too.

    +10

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events