GSquared (6/29/2009)

---

I have a Dilbert strip, the XKCD about Little Bobby Tables (search that if you don't know it, required reading for DBAs), a picture of Darth Vader with "I...

Ha. That's better. More compact than the version I posted before, and...

GilaMonster (6/29/2009)

---

I didn't say it was daft, I just said I don't know why anyone would do...

No worries.

Well in case...

😀 Don't tell me about it - I didn't post the daftness!

Paul

Peso (6/29/2009)

---

I only have 92 column in my master.sys.columns.

This is because I have an edited very slim version of MASTER database.

This is not something common, but you should beware that...

Sinshith S Anand (6/28/2009)

---

Actually i was expecting different methods for counting 1 to 100.Methods using CTE,While loop,Go to,Cursor......I was expecting some different methods than this...Gail posted a different method...Thats why...

You have a proper Dilbert-style cube? :w00t:

Lynn Pettis (6/28/2009)

---

Jeff is correct. I'm not asking what he meant by "correct". To state that he had only one correct answer when multiple posts had correct solutions...

I have no icons for how funny that is.

Jeff Moden (6/28/2009)

---

By the way... when they actually do install the handrails, tell them to...

Grant Fritchey (6/28/2009)

---

Every time I ran the query, it picked the widest set of includes, regardless of the order in which the indexes were created. I didn't check reads or...

lmu92 (6/28/2009)

---

You're definitely right: the solution I came up with is faster only under a special kind of data distribution. The break even is around 65% of the rows (if...

Cool - so you have identified the cause.

Now you need to change the program so that it inserts a NULL instead - if your variable has not been assigned to.

I'm...

Guys,

Does it really matter that much what was meant by the word 'correct'?

Taking the poor guy to task over semantics seems unfair.

Paul