• I've got just the thing for you. Check out the /MIR option. And, the three best things are 1) you probably already have it and 2) it's free and 3) it only requires a single command.

    http://technet.microsoft.com/en-us/magazine/ee851678.aspx

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)