Not sure about the questions, and given Celko I don't think the posted answers can get much worse, but this question got a first answer asking for sample data, so...

harrd007 (7/28/2012)

---

hi

We need to combine two DML Statement into one statment

update B

Set B.phone_disp_new = ISNULL(A.value,'Other')

from test22 B

left outer join test21 A

on B.ph_phone_new = A.TGA_CODE

update B

Set B.phone_disp_old = ISNULL(A.value,'Other')

from test22...

If you want the attachment to be CSV, you need to change

@query_result_separator ='',

to be

@query_result_separator =',',

Quite a nice editorial. I guess I agree with most of it - although I agree even more with the comment Gus posted on Monday.

The flagpole idea is interesting....

I didn't read beyond...

Good straightforward question.

But in the explanation: is that really the parsing order, or are you assuming that's the parsing order because it's the execution order? I don't think I've...

Nice straightforward question.

The reference given is am SQL 2005 note, which does say it also applies to SQL 2008. There was a connect item on this which was closed...

David Burrows (7/27/2012)

---

With these language problems maybe we should ask Steve to create a new IFCode <sarcasm></sarcasm> to highlight sarcasm including a caveat

'If you take offence with this sarcasm...

It seemed to me that two of the five options could be eliminated easily (assuming we didn't have someone rather unpleasant setting the question, a natural assumption for me because...

C-Note (7/27/2012)

---

L' Eomot Inversé (7/27/2012)

---

C-Note (7/27/2012)

---

This was exactly the question I was stumped on and exactly the logic...

GSquared (7/27/2012)

---

L' Eomot Inversé (7/27/2012)

---

GSquared (7/27/2012)

---

Brandie Tarvin (7/27/2012)

---

Back to the semi-technical discussion...

If joining a VARCHAR(8000) to a VARCHAR(MAX) value degrades performance, how does one get around this?

I'm not speaking in...

C-Note (7/27/2012)

---

This was exactly the question I was stumped on and exactly the logic I followed in assuming...

sestell1 (7/27/2012)

---

Ah, but LEN() is not comparing strings, it's supposedly returning an individual string's length... except it doesn't. It rtrims the string first, then returns the length of the...

WayneS (7/27/2012)

---

Brandie, I was just trying to...

sestell1 (7/27/2012)

---

SQL Kiwi (7/26/2012)

---

L' Eomot Inversé (7/25/2012)

---

Hugo Kornelis (7/11/2012)

---

In my opinion, it is LEN() that has the strange behaviour here, because it returns the length of the padded version of...