Viewing your boss as a customer is not a bad idea (in fact I quite like it), BUT

In my experience, customers tend to give more feedback than most of the...

Jeff, thanks for the link. Your article made a lot of sense. Not to mention that the code for the tally solution is much more simple and easier to...

Hi David

I quite like your idea of using CTEs and recursion to build a calendar, but when I ran your CTE(View) I got a MAXRECURSION error, so I edited it...

WayneS (2/22/2010)

like this... you don't need to cast ROW_NUMBER to an int... it already is

select top 100

case

when ROW_NUMBER()...

Jason and Jeff

As far as scaleability is concerned, I did try it with 1 Mil. rows which didn't work in my master database (SQL 2008 dev edition). It topped out...

Hi jcrawf02

How would you change it to avoid the cast?

Hmm... The reply didn't work the way I thought it would.

My question was in regard to your comment on my solution...

OK then let my chuck in my fifty cents.

I haven't had time to read all comments, so I don't know if a similar solution has yet been provided. I really...