Jeff's link is excellent for your solution. You can also go thru this links:

http://codeinet.blogspot.com/2006/08/auxiliary-calendar-table-for-sql.html

Hi

As per microsoft:

A CTE can be used to:

* Create a recursive query.

* Substitute for a view when the general use of a view is not required; ...

The interview was good. Can we have more interviews like this with different experts? Can we also participate in a live interview?

🙂

Kudos to Micheal for writing a good article......

🙂

Hi Roberta

I am late to join this discussion. Did you explore this library http://msdn2.microsoft.com/en-us/library/ms177673.aspx

It is a mine for T-SQL statements. I think most of your queries should be...

Good article with decent examples. Cheers!!!!:)

Great Interview!! Can't wait for the second part........

A very cool article. One of the best written article in this forum. Cheers!!!!!! :w00t::P:):hehe:

Thnx guys for all ur solutions. Also thank the author for an article.

😛

Go thru this article:

http://www.sqlservercentral.com/scripts/Administration/61766/

Also go thru the dicussion forum on this article. There are couple of solutions which work fine.:P

The article can be a base for further research work. Otherwise it is good. 🙂

Overall it is very decent article. Chers to the author. 🙂

Good article. The concept will be more clear when I started to use SQL Server 2008. But kudos to the author.

You are welcome and glad to know that my links where helpful.

😛

Part I of the article is good but I am more eager for its Part II. I will request him to write fast the Part II. 🙂