callie97 (11/30/2011)

---

I got this question 'wrong' because the result of my query came back with v3 = v2, not v2 = v3. The value in the result set is...

Cadavre (11/30/2011)

---

L' Eomot Inversé (11/30/2011)

---

I replied too quickly before, didn't cover all bases before getting it wrong. I knew there wasn't a typo in the question, and didn't consider...

Cadavre (11/30/2011)

---

L' Eomot Inversé (11/30/2011)

---

wloong (11/29/2011)

---

I agreed!

From the programming logic, "v2 =...

gary.mazzone (11/30/2011)

---

Since the version is not specified if this is run on SQL Server 2005 then the Answer needs to be None of the above. Why do we ask.......

Hugo Kornelis (11/30/2011)

---

Tom, please double check the question. The SQL text contains the string constant 'v3 = v2' as one of the CASE results. The correct answer option reads v2...

Henrico Bekker (11/30/2011)

---

Hi Tom, if the question is "what would the statement return" then "v3=v2" is in fact correct, because that is what is returned when executing the code.

I have...

Thomas Abraham (11/30/2011)

---

Good question, excellent explanation. Now please explain:

Crois-tu qu'on s'enivre pour s'amuser? Etre ivrogne ce n'est pas une sinécure... Si tu savais l'attention et la persévérance qu'il faut! Toujours...

erroneous post

stupid erroneous response edited out.

stupid erroneous repsonse to comment. edited away.

Guantanamo

Good question.

It caught me, although it most certainly shouldn't have :blush:. Guess I shouldn't try to understand SQL until the hangover subsides :doze:

Kiara (11/28/2011)

---

"rich idle"???...

Yes - changed avatar to match sig. Also changed sig to different quote from same author because one of the ladies reacted to the...

Haaaaaave you been conversing with too maaaaaany lambs away?

Because they had...