Interesting. I didn't know the Gregorian calendar adoption for the British Empire was in 1752. All the history I studied talked about the Gregorian calendar being created in the 1500's,...

"Why use a spoon?"

pastries

DOH. I wrote the original query wrong in this thread. I did use Datepart. Honest.

Still odd how it transformed it, though.

Tom.Thomson (12/16/2010)

---

And on coalesce, you were just making yourself look silly. Don't let the fact that Celko often (usually?) writes in online fora as an obnoxious *** blind you...

No. I don't use keywords or functions for column & table names.

Email them over to me. I'll eat them. @=)

Lamprey13 (12/16/2010)

---

Brandie Tarvin (12/16/2010)[hrYou're missing the point of my comment. He's trying to match a potentially NULL value to another value. You can't do that with a function that is...

Steve Jones - SSC Editor (12/16/2010)

---

I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds a new...

Lamprey13 (12/16/2010)

---

Anything you've read by Kimball should be forgotten. If you still have the book you read that in (assuming it was a book) you should burn it now to...

It would help if you provided the list of errors so we could help you better.

Daniel Bowlin (12/16/2010)

---

Ray K (12/15/2010)

---

sing4you (12/15/2010)

---

Cool! What are you playing?

I just sang, played piano, and bass guitar (not all at the same...

The key to keeping your throat from getting sore is to not swallow that stupid frog in the first place!

😛

Actually, the breathing thing I mentioned on page one of this...

GSquared (12/16/2010)

---

I used to know a DBA who insisted on using 1-letter aliases for all tables in queries, because it made them "faster to type" in the other parts of...

Dave Ballantyne (12/16/2010)

---

Sounds dangerously...