Non sargable mightmare

Question

Non sargable mightmare

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Jeff Moden (7/2/2008)
GSquared (7/2/2008)
cast a curse of impotence on the original coder and all his descendants for a thousand generations
Ummmm... isn't THAT a bit of an oxymoron? 😀

Didn't say it would work! 🙂 (And, yeah, that was the point.)

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

GSquared (7/3/2008)
Jeff Moden (7/2/2008)
GSquared (7/2/2008)
cast a curse of impotence on the original coder and all his descendants for a thousand generations
Ummmm... isn't THAT a bit of an oxymoron? 😀
Didn't say it would work! 🙂 (And, yeah, that was the point.)

Not to get overly far off topic, but no...that's not exactly an oxymoron. One body part not working doesn't mean the other one isn't. It would involve a lot of visits to a specific kind of specialist to "facilitate" said 1000 generations of impotent offspring, but still - technically possible....

Still sounds like a fitting punishment.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 3

Matt Miller (7/3/2008)
but still - technically possible....

Maybe THAT'S where you should use a cursor! 😀

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

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 4

Jeff Moden (7/3/2008)
Matt Miller (7/3/2008)
but still - technically possible....
Maybe THAT'S where you should use a cursor! 😀

I'm assuming that's what the poor specialist would be doing...cursing...a LOT....:w00t:

Hey - color me confused. I always thought a cursor was what you called a scottish sheepherder not knowing how to properly use the 2 bricks....:hehe:

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

OleHank SSChasing Mays Points: 654 More actions · Answer 5

Thanks for all of your replies. They made me laugh, even if they only confirmed what I already knew!!:D