Yes, thanks. I ran into this puzzler and posited the question initially under the heading of 'how hard can it be.' Looking forward to your reply.

Grasshopper, Thanks for the links!

You're right! My problem was w/ Northwind (SQL version) not the script.

Thanks 4 the feedback - and thanks for a handy routine!

I'm getting syntax errors in SQL 2008 in the Northwind D-Base beginning with this line...:

WITH cte_date_base_table AS

Also it doesn't recognize ROW_NUMBER as a function name.

Help!

SVonTilbon