For a SQL Server 2000 (and prior) dinosaur like myself, the whole concept of defining a Common Table Expresssion (CTE), never mind a recursive one, was new to me.

If anyone else is in the same boat, I found the following article very helpful:

http://www.4guysfromrolla.com/webtech/071906-1.shtml