Archie,

You are correct. That was an over sight on my part. I didn't test it with SQL 2000. The question should have stated that this was for...

Hugo,

Thanks for the feedback. I agree that the explanation could be better, but through my research on the topic, I couldn't find an adequate explanation for this behavior. ...

Disregard my last post. I just realized that the SQL Server Express server is not in mixed mode, which probably accounts for the NULL.

Greg

I tried it on several of our servers, both 2005 and 2008, and received '1900-01-01 00:00:00.000'. All of these were enterprise edition. I also tried it on one...

Today is also the day that the Titanic sank and President Abraham Lincoln died.

Doh!! Someone beat me to it!

Great job, Craig! This is a great idea for a topic. One that isn't discussed often. I cannot count the number of horrendous job postings that I...

Yes, it was possible to move the resource database in SQL2005.

http://msdn.microsoft.com/en-us/library/ms345408%28v=SQL.90%29.aspx

Thanks,

Greg

Very disappointing. This is a fairly basic question. A little proofreading could have prevented this from becoming a bad question.

Kanaka (7/19/2010)

---

I am not sure why sql server 2008 returned 1, inspite of not giving the variable length.

I knew this would give a syntax error, however, I tried this and...

Thanks for all of the feedback. I definitely should have considered case-sensitivity, especially since we have several case-sensitive database here. In hind sight, I should have made everything...

This is straight from the link supplied in the answer.

SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the same...

I'm a big fan of using surrogate keys when designing databases, but they are not intended to enforce data integrity. They should be used to simplify joins and used...

You can't use a variable to pass in that DATEADD parameter. The only way I know of to do what you're attempting is to use dynamic SQL like this:

DECLARE...

They're not being used, so they shouldn't affect it at all.

Greg

Year would be another column and the query is looking for 2008.

Greg