• labri (4/19/2013)


    Thank you all for your answers! I found what I needed using the

    Alan.B's query.

    I'm glad that worked for you. It is worth noting that my query was pretty much the same as wolfkill's query. So much so that I almost did not post mine (but I spent some time on the query so I wanted my 1 point.)

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001