Never heard of it. Thanks for a question that made me look it up.

+1 I really liked this question. I don't use XML in...

Nakul,

Nice article. One small problem I noticed was that the constraint for being 18 years old was given as:

(DATEDIFF(YEAR,BirthDate,GETDATE()) >= 18);

That won't give the correct answer when the birthdate is...

If I would have noticed it was worth two points, the pressure would have got to me, and I'd...

I was surprised, and pleased, at the level of detail in the explanation provided. Nice job with that, and the question, Lokesh.

Thanks Stewart for the info.

Got it wrong, but also got this when I ran the script in SQLCMD mode:

Running on 2008. Is it just...

Raghavendra Mudugal (1/22/2014)

---

Thank you for post, Good one Steve.

(actually, couple of days ago tried it on SIMPLE model, and was sure (to my knowledge) that it will work on this...

Excellent question on an interesting topic. Thanks much to the Devil.

My complaint about Excel is not the product, but the people that use it, er misuse it.

I can't count the number of times I've been asked/forced to make an "application"...

Knew the first two were wrong, but had to make a guess (wrong) about which of the remaining five was wrong. Thanks for the question.

raulggonzalez (1/17/2014)

---

Thanks for the question, but I have to disagree with one of the answers.

I have a number of offline databases in one of my servers and the following query...

Bless you Ron! This has solved an issue I was having...

Personally, I'd like to thank everyone for the craftperson-like way they discussed this issue. :hehe: (I hope that's the last time I use "craftsperson-like".)

Dennis Wagner-347763 (1/16/2014)

---

The solution seems to be to calculate the days for comparison purposes. Then, add the days to a standard reference date, such as 1900-01-01. THEN do your DATEDIFF...