Thank you for the question.

At the risk of sounding cliche, I am pretty surprised that this many people are getting this wrong. I am especially surprised about the number...

Thanks for the story, I really enjoyed it. It hammers home the point that you must be careful what you ask for.

Great post, Steve.

I tend to think of basic skills as the foundation you build your more advanced skills upon. If you allow this foundation to deteriorate and fall into...

I have pretty much the same limits on commute. Thirty minutes is pushing it for me. I currently drive twenty minutes to work, and it is tolerable. ...

This is a point that I am constantly reminding my management...

Thanks for the question! Even though I got it wrong, I learned something.

Matt

Jeff,

Thanks for the article and the performance metrics. After having read it, I will be sending a link to all of the developers in my department as a means...

I enjoyed this question. Thanks!

We won't be able to see...

Brian, thank you for the great article. It has shed some light on a very interesting topic.

The combination of an iPad and Red Gate SQL Server Monitor offers mobility, ease of use, and increased visibility. Mobility is a given: the iPad is a lightweight...

Nice, straight-forward question. Thanks!

It means exactly that. There is an error near the character '7'. In order to help you further, I will need to see the whole query, not just...

Try this:

CASE

WHEN [Request_UDF,End Date] <= '01/31/2011' THEN 'Phase I'

WHEN [Request_UDF,End Date] BETWEEN '02/01/2011' AND '03/31/2011' THEN 'Phase II'

END

Matt

First, you are presumably attempting to compare the integer returned by datediff to a date, but since that date is not enclosed in single quotes, you are actually comparing the...