You're so right, feeling very silly right now. That's it, no QoD on Friday, my brain obviously has shut down from this week.

Umm, it may be that my brain is fuzzy on a Fri morning, but isn't Select datename(m,'2008-07-12') = 'July' (in English) which I'm pretty sure doesn't have an "e" in...

Well, admittedly, I live in a high tech town, so maybe my observations are skewed somewhat. I've had recruiters calling me (unsolicited) at a rate of once/month. All of the...

Once I determine that the question (as many ppl have pointed out) didn't know the difference between nvarchar and varchar, I treated those two columns as varchar...Unfortunately, I didn't get...

The reason 1752 dates throw an error, is that it was during this timeperiod that the British empire switched to the Gregorian calendar. During 1752 there was no Sept 3-13th....

I had gathered that what you hoped was that you could remove the 00:00:00.000 from the result, but as I stated, with a datetime data type, you'll always get the...

That'd be because the data type is dateTIME.

If you want just date, convert to SQL 2K8 and use a date only datatype, or as previous example above have done,...

I used the Cast/Floor/Cast method myself, although often it's just Floor/Cast, since integers are implicitly converted to datetime. (For this reason, on some tables, I store an int for date...