• Chris,

    Both answers above are technically correct but if you want a coded answer, you'll need to change this...

    Mea Webb t0022165 1 2010-02-15 00:00:00.000 0

    Carlos Banuelos t0021988 1 2010-02-15 00:00:00.000 0

    Vijay Brock t0022220 1 2010-02-15 00:00:00.000 -1

    Steven Castorena t0021773 1 2010-02-20 00:00:00.000 0

    Lashontaya Beaver t0022140 4 2010-03-14 00:00:00.000 0

    ... into some readily comsumable data. See the article at the first link in my signature line below for how to easily do that.

    --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)