• thomashohner (5/4/2014)


    On the million record test data... I know what I'm doing today:-D

    Do you use a While Loop or Recursive CTE to make your test data?

    Thanks so much for your reply Mr. Modden.

    Heh... just a tip from an old dude that has seen a whole lot of water pass under the proverbial bridge... THAT's the one thing that you should absolutely sweat bullets over. While it's good to be humble and thankful, spell the name of your boss, other higher-up, or even a peer incorrectly and see how many points you earn especially if the name has only 5 characters in it. 😉 Personally, I'm not insulted outside the work-place but wanted to tell you that a whole lot of people are much more sensitive to it. I've found that such a simple faux paux in communications will cause many higher-ups to think "Gee... what kind of attention-to-detail does the person really have when they won't even take the time to spell my name correctly?' I also take the time to learn to pronounce even difficult names correctly. While some claim to understand and accept mispronunciation of their complex names simply because they are complex, you can really get their attention and develop incredible working relationships just by taking the time to show them they're important enough to learn to pronounce their difficult name correctly.

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