• GilaMonster (11/27/2007)


    Nice. I'm also a little tired of people looking for a free lunch. Problem is, those who need it most will likely not be the people who read it.

    Heh... I know exactly what you mean, Gail. I've even had people post that it's my job to give them an answer on the forum despite the fact they've posted no code and no data and the principle behind their question defies every good rule of RDBMS usage. Of course, if you ask them why they want to do such a {bad} thing so you can help them find a different/better way, they either get real indignent, provide correct but undetailed answers like "It's for a Report" or they simply go away.

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