Thanks for the great question.

Nice question to start the week. Thanks.

Great question. Didn't know the answer off the top of my head but dug into the CONVERT command and got it. Thanks.

Thanks for the question. An easy one, but I did refer to BOL to make sure before I answered.

Nice easy question. I was looking for the trick and was very careful to study the data in the two tables but it turned out to be straight forward. Thanks,...

I don't know if this is any help but it is what I used to answer this question:

http://msdn.microsoft.com/en-us/library/ms142491.aspx

http://msdn.microsoft.com/en-us/library/ms142491(v=sql.100).aspx

Yay. Great question. Had to do a lot of research to get it right. Thanks.

Thanks for the question.

Thanks for the question. Great Friday question to end the week!

Thanks for the question. I need review with date types.

Great question. I also got the answer by running: " EXEC tempdb..sp_help '#TempQoD'; "

Great question and easy. Thanks.

Dave62 (3/11/2013)

---

Thanks for a great question Ron.

I'm thinking about including a question like this in an interviewing process. Based on the current responses I think it could be very effective...

Thanks for a very good question.

Thanks for the question. It got us all thinking and complaining which isn't a totally bad thing.