By the way, for anyone who wants to try how these variations cann affect the result set, here is the set of test data I used when prepaaring this question:

CREATE...

honza.mf (12/6/2011)

---

Hi!

I don't understand how the condition AND o.OrderDate > DATEADD(month, -4, CURRENT_TIMESTAMP) in SQL Query #4 works. For me it seems it is to...

Thanks, all, for your kind words. It;s always good to know that my questions are appreciated.

Tom Brown (12/6/2011)

---

I had never heard of Nested Joins, so learned something today.

However my...

Thanks, all, for the kind words. I figured a not-too hard yes/no question would make for a nice change of pace. (It being scheduled on a friday is not my...

Well, I guess the issue is that the SQL Server...

Nice question. XML is one part of the database I am still struggling with. I first ticked the answer I thought was corerct without submitting, then went to the dosumentation...

There is no connection between sql_variant and...

Gerardo Galvan Castro (11/30/2011)

---

In the e-mail newsletter the QotD did not state it was for SQL Server 2008 and later, so I tested under SQL Server 2005 (the only version...

Removed.

I must learn to read first, write later. Sorry!

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 = v3....

Toreador (11/30/2011)

---

Same here, but...

Good question. Thanks, Tom! 😉

To me, it was immediately obvious that the v3=v2 / v2=v3 error was a mistake made when entering the question and not a deliberate trick.

codebyo (11/29/2011)

---

I usually code my INSERTs like this whenever possible:

INSERT INTO #ATable

(

Col1,

Col2,

Col3

)

VALUES

(

2 AS Col1,

1 AS Col2,

3 AS Col3

);

I'm not sure if it's a good way of doing it but it...

Nice question. Not terribly hard, but interesting. It could have been made a bit harder by omitting the column list in the INSERT:

INSERT INTO #ATable

SELECT 2 AS col2, 1 AS...

Technically, T-SQL is not using single quotes for both strings and dates. It uses single quotes for...