I chose the correct one by calculated chance. I assumed that if the question was entered by a human,...

Thanks Steve - great question.

Tally tables and set-based thinking - this should be the first topic users of SQL learn after CRUD when picking up the language. My personal...

I was thrown off by the values in the question. It states:

If I have this data?

CustomerID Sales

1 ...

Must be Monday. Read it as how many columns instead of how many rows. Fortunately, I stopped for some coffee on my way in to work and was...

Hany Helmy (9/16/2014)

---

Still not convinced it`s important...

Ed Wagner (9/15/2014)

---

An easy one to start the week to be sure, but it had me re-reading the question 3 times and looking at the code a couple of times...

Brought a smile to my face... thanks!

While I agree with previously commented sentiment that these are purposefully confusing questions and therefore should be avoided, I also agree with the interesting...

Good question - thanks for sharing.

I'm curious how many shops out there have adopted ;WITH as a standard practice?

We have purposefully avoided it here in favor of terminating all applicable...

My 2 cents is that I enjoyed the format of the question. Shows the creative touch that so often has to be suppressed in the tyranny of the urgent!

HanShi (6/6/2014)

---

I was in doubt, because I found it difficult to get the intention of the question (perhaps because I'm not native English speaking). Did I need to take the...

Thanks for the question, Gerald.

Thanks Andy - well written QOTD with explanations.

Thanks Hardik. Nice question.

Ever focus on something too hard? I looked at this question and did some research. Determined the correct answer, then proceeded to select the wrong one... :blush:

Thanks for...

+1