• I agree... I've never asked such trivial questions as to how many columns a table can hold for the very reasons that Gus stated. My point was meant to explain simply that wrote memorization of sometimes incorrect "trivial facts" are not sufficient to pass an interview unless the interviewer is also clueless.

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