Oracle has a CONNECT BY clause to do recursive joins like this - not a
help to you as such, but the point is that they have found it necessary
to have a specific feature to accomplish what you're trying to do. They
used to call the technique "tree walking". Don't know if SQL Server has
something similar ...