Truly excellent article, as always. Thank you Jeff.

While working on the financial calendar suitable for retailers several years ago (whole weeks, 4-5-4, the year begins in first week of February...

This is a very good question which clearly demonstrates the consequences of failing to pack the precision in order to avoid any unwanted rounding. It might be tempting to declare...

The choice of "4 columns 3 rows" does not appear to be correct, but it is the closest, so this is why I chose it. The correct choice should probably...

I agree with giorgos.altanis on this one, i.e. this is certainly NOT...

cengland0 (7/20/2011)

---

Thanks but it's not about the points. I'm a perfectionist with OCD so I take these QOTD's very serious. I think of them as a test of...

Ninja's_RGR'us (7/20/2011)

---

I had considered that as well. The case statement is a technic that I use once in a while so that has value all by itself.

The title is...

What I don't understand is what does the title of the question have to do with any part of it? Here is what I mean: commenting out the where clause...

GSquared (5/20/2011)

---

I can't get your link to work, so can't check what you referenced there, but the question was about Filestream, which is NOT in the database. That's a...

Well, these were not the choices....

SQLkiwi (12/28/2010)

---

Or, even more succinctly:

WITH Records (Old_Seq, New_Seq)

AS (

SELECT Seq,

...

This is a good basic question, thank you. One thing I would like to point out is that the update script in question is more complex than it needs to...

This is a very good back to basics question, thank you.

The behaviour of the exec in this case is identical to the one of the stored proc where the temp...

This example shows how to quickly populate a table with successive dates? Not really, it shows a pretty convoluted way of doing it, not quick. Any time there is a...

Stefan Krzywicki (12/1/2010)

---

I wasn't saying he was wrong, I was looking for clarification since going for a NOT NOT seems an odd way to go about it. So

NOT LIKE '%[^0-9]%'

means...

Stefan Krzywicki (12/1/2010)

---

Sorry if I'm being thick, but at the end of the article, referring to NOT LIKE '%[^0-9]%' you write

The reason why the formula works is that the "^"...