I got my hands on a 2005 server to test on and the cte works well. The only change I made was that I changed the last entry to +1...

You are correct Lynn.

CTE is SQL2005 only and my server is a 2000

Thanks for the tip.

I assume you are referring to http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Unfortunately, this only has a SQL script download and that script does not seem to apply to my situation....