• manie (4/17/2016)


    Jeff, my sincere apologies, I did not mean to take you on like this and I fully agree with you. You know, I have been a developer now for 17 years and about 3 years ago the company I work for threw me in on the deep side and told me that I am now responsible for the administration of the database and server and although I always thought I was proficient in SQL I suddenly realised that I have a mountain of stuff to learn. Even still I never expected anyone to just put something in my lap. So, if someone ask you to hand them a script already written like the example Gary used I won't blame anyone if they just plain ignore them.:w00t::w00t::w00t:

    No need to apologize, ol' friend. I knew what and why you were asking and my original jab at it was way too short to convey the real meaning behind the all too short post. Perhaps some people just don't know what they don't know but you, for example, wouldn't put on your resume that you had more than 10 years of database administration experience because you're one of the honest good guys. I've been dealing with the folks that either aren't so honest or just don't have a clue as to what it takes.

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