Thank you Bob!

I understand why people don't want to just do other people's work, there are times in these forums I wonder if the original posters ever even heard of Books Online or MSDN. I understand also why people typically request the questions be posted in a specific way, with CREATE TABLE... INSERT... instead of just listing the contents of the table like this post did. I remember the first time I worked with a recursive CTE though, and they do take some getting used to. Even though I've written recursive queries before on Oracle with the CONNECT BY syntax. Or maybe I'm just not challenged enough at my current job and need to feel usefull :hehe: