This makes my decision to retire at 56 much easier 🙂

Final.Answer!

http://msdn.microsoft.com/en-us/library/ms174205.aspx

According to that document - CTRL + 2 runs sp_lock (system stored procedure)

do you get any results when you select rows using the same where clause?

From http://technet.microsoft.com/en-us/library/ms187912(v=sql.105).aspx

Approximate numeric data types do not store the exact values specified for many numbers; they store an extremely close approximation of the value. For many applications, the tiny difference...

I agree with much of what has been posted here.

I try to help - but have been told many times that I need to learn to say no.

I do keep...

paul.knibbs (10/15/2014)

---

Maybe the author chose the column name deliberately to catch out people who just run the SQL rather than thinking about their answer? I mean, the error about incorrect...

I've come to the conclusion that I should never answer the Friday QOTD until Monday morning.

I am on the "less than 5 years to retirement" team. I am hoping for less than 1 - but am only confident of less than 5.

Lynn Pettis (9/4/2014)

---

Yes, I actually threw one of Mr. Celko's own arguments back at him in a post talking about dates.

I liked the COBOL reference since he likes to use...

CELKO (9/3/2014)

---

A few decades ago, when I started posting on CompuServe, etc. I was super-polite and politically correct. Nobody heard me....

CELKO (9/3/2014)

---

You doing everything wrong. Where is the DDL? That is minimal Netiquette in SQL forums. Is this all INTEGER math? I hope not! But that is what your coalesce...

I have no words....

Don't

SELECT distinct jNMBR, sNMBR FROM #myTable

except (select jNMBR, sNMBR from #myTable where cDate is null)

reverse