• Ed Wagner (11/13/2015)


    Jeff Moden (11/13/2015)


    This is actually pretty sickening. Why do you even bother going to school if you're not going to even try. You should drop the course if this is the way you intend to pass your courses.

    Amen. The world already has enough 9-to-5-ers who always do the same thing the same way and never even realize they're in a box. 😉

    Then again, education has become more about getting a piece of paper than about learning. It's a sad situation where people pay such huge sums of money for a piece of paper and don't take advantage of the opportunity to learn something.

    It's sad, indeed. What's really sad is that I just realized that I've been reduced to producing Celko-like guttural utterances of no particular use on questions like this one because I'm so incredibly angry about people not only not being able to solve such problems nor do they even read the problems with any fore thought as to how the code will operate in the future, but that (at least the, ummm... "candidates" {yeah... that's a nice word for them} that I've been interviewing) these are the same people that are demanding a salary of between 90K and 115K USD and bloody head-hunters that also don't know better are helping them get it at companies that also don't know better. What really get's my goat is when the head hunters get mad at me when I tell them that the candidates they're sending are NOT senior level candidates no matter what their resume says.

    Heh... and don't get me started on 9-to-5'ers that make no investment in themselves unless the "company pays for it" (haven't they already paid enough by not getting what they paid for by hiring them?). Of course, if you look through Books Online and most MS books, you won't find any mention of how to correctly do even problem #1 on the original post so even if folks were to get training, it wouldn't actually give them enough information to solve either the current year problem or the SARGability problem.

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