Nicely said and nicely written, Steve... I'm not so generous in my thoughts about these kinds of Developers/DBAs (and I use the term loosly for folks with this type of...

Not trying to be a smart guy here, but this very open...

Just my 2 cents... you don't need CTE's for this... don't even need derived tables... just the Cross Join...

SELECT t1.N AS Month, t2.N AS Day

FROM dbo.Tally...

I agree with Sergiy... life would be a lot easier that way... create a "Gold Set" of scripts or even an empty database to copy from.

Heh... I'm thinking "tie" and I'm thinking that, once again, only RegEx replace beats T-SQL... you sure it can't be done using some magic RegEx replace?

And, by the way, I...

SELECT CEILING(CAST (12.2 AS FLOAT))

You do realize that your table is a bit denormalized? Can't you turn it into a true EAV (Entity, Attribute, Value) table?

Splitting free text names is a huge pain in the patoooti... For example, two-part first names, middle initials, and a host of other formatting sins (FullName being the first sin)...

Steve, do you have a URL handy to sign up?

Only if the tuning Wizard says so... haven't figured them well enough to do it on my own, yet... I guess it is a possibility here...

Heh... you started it... was hoping you had some final code 😉

Ooohhh... not good. Just wait till you try a bunch of inserts that are close to each other for the cSpecialty column... it's a 4 letter word... WAIT....

Sorry, Gus... we're posting in parallel...

The -1 addition will work but I think the tweek needs to be extended to the days column, as well.

GSquared (4/14/2008)

---

Jeff, good article. Just to add to it, you can do this:

declare @D1 datetime, @D2 datetime

select @d1 = '02/Nov/06 9:14:21 AM', @d2 = '19/Apr/07 11:52:31 AM'

select datepart(year, @d2-@d1)-1900...

Matt Miller (4/14/2008)

---

As of right now - "straight...