• In just about anything I've seen having to do with software, 99% of the people only know how to use 1% of the functionality. A lot of the new flash-in-the-pan software is to try to get the next generation to buy the latest version (gotta keep up with the Jones' :-P) with 1 or 2 "slick" things that can usually be done without the "slick" if you just take the time to learn it.

    I've seen a whole lot of good functionality in SQL Server simply go away along with some of the good stuff they added... I wonder when they'll add some of it back in so you can buy a new version to get it and think its new and "slick".

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