The question in the daily newsletter was:

"Will all these statements when executed as a batch return the same date, hour, minute and second?"

Now I see that the question on the...

The moment I checked the answer I knew there had to be a catch... While I don't agree on the assumption about distribution of the average I still like the...

I agree, in my opinion GROUPING_ID belongs to the SELECT clause, not the GROUP BY clause.

Even Wikipedia doesn't know:

"Rudolf Bayer and Ed McCreight invented the B-tree while working at Boeing in 1971, but did not explain what, if anything, the B stands for. Douglas Comer...

I totally agree, this was a few years back. In my current environment it's no longer possible for me to make these kind of mistakes.

Ross McMicken (9/1/2009)

---

PostXript (9/1/2009)

---

Oops... that closing...

Oops... that closing sentence hurts... glad I'm not the only person who ever did that 😉

According to the definition it should be Language INtegrated Query, with a capital N also...

Not for me:

CREATE DATABASE failed. Some file names listed could not be created. Check related errors