• I think this is a nice little article illustrating a good, systematic method for attacking complicated queries:

    http://weblogs.sqlteam.com/jeffs/archive/2007/04/30/60192.aspx

    ---------------------------------------
    elsasoft.org