I got this answer right because I was raked over the coals regarding % in the now famous SSC thread The T-SQL Quiz. The school of hard knocks, as...

"What is irritating is when people get all in a huff about the 'greedy rich' and thinking that the reason these people are poor is because those people are rich."

I'm...

"Beware of programs implemented just for the sake of posturing ('Look at me, I'm doing something to help the poor!') More often than not, such programs are actually counterproductive. If...

Perhaps your pro-bono suggestion could be combined with a site similar to Donors Choose. Donors Choose is designed for teachers to propose projects they need but which their schools...

Thanks - that makes a big difference!

Some constructive criticism: I see this has been mentioned, but the picture is of a Native American, not of a South Asian Indian.

I don't think this is an issue of...

I think there are two ways that certification can be useful.

The first way is as a starting point for further growth. One can take a brief, whirlwind class that shows...

This thread should be printed out and preserved in acrylic. It was as much a Rorschach test as a SQL test. The responses perfectly illustrate many of the good traits...

Yes, I agree. All I was saying was that you eventually do need to learn real-world SQL, and learning only C.J. Date will not provide that.

In other words, I...

"His instinct is to simply ignore the things that he doesn't understand, and try to figure out how to accomplish the task anyway."

I think this is more of a problem...

Yes, I see your point. I think that programming theory (and relational theory) courses should be offerred, since they should be available to show students that if they want to...

So it really irritates me when I read editorials that say "we should be teaching more SQL" because if anything, we should be teaching LESS SQL and more relational theory,...

Great editorial!

Also, there should be more practical SQL taught. Not enough students are taught real-world SQL or basic database design. Perhaps if there is a robot in the curriculum,...

Hello Jeff,

Thanks for your function - I am very happy these threads live on!

I think you are right - SQL datetime formatting hasn't changed much as far as I...

Thanks, Jeff!

I haven't had a chance to install your version, and luckily it looks like I will be able to allow the default SQL datetime formatting and the calling script...