I know this isn't going to be what you want to hear, but the code is just wrong. It appears that you are trying to nest a CASE inside...

WayneS (10/4/2010)

---

Alvin Ramard (10/1/2010)

---

Ok, time for me to put what's left of my reputation on the line. I predict that the Thread will hit 20,000 on Thursday, Oct 7th,...

Had to look at the OP on that drop database thread, OH, is all I had to say at first. I did leave a comment after reading through the...

As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can recover it...

Ron,

Unfortunately, complaining here on SSC probably won't result in the response you are looking to achieve.

Second, the problem you are complaining about isn't unique to Microsoft. You will find...

Based on the OP second post, it appears that the year is stored as the last two digits of the year as an integer. Meaning that there is no...

Here is another method:

dateadd(dd, ININVD - 1,

dateadd(mm, ININVM - 1,

dateadd(yy, ININVY + 100, cast('19000101' as datetime))))

Can't test this from where I am at, so hope it helps.

Not missing anything other than me leaving something while typing on my blackberry. Looks like your year value is two digits, no leading zero, is this correct?

Back in a...

Part of this depends on how the values are stored, as INTs or CHARs. Is the year stored as 2 digits or 4?

If stored as INTs, one...

Ron Kunce (10/3/2010)

---

Lynn,

I am sure you are partially right about earlier editions, even though I could have sworn at one point Microsoft was giving away developer editions of 2000...

It would help if you provided the DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data (as a series of INSERT INTO statements), and expected results based on the...

I don't recall the developer edition ever being free. I do remember to cost $500 USD prior to the release of SQL Server 2005 DE which was priced at...

That's what hurt me this last week, a player out (not a bye week). Shoulda checked on Saturday, but was up and out for SQL Saturday 52.

Live and learn!

I would have to disagree. Celko's responses that I've read have almost always been arrogant, pompous, and tactless. I have seen his attitude change once when the OP...

I don't know,...