Hi Atif, in many ways I'm still a relative newbie to SQL Server... your example of a recursive CTE is probably an old technique to some of the regulars, but I'm sure glad I've found out about it!
However, I was wondering if this is guaranteed to maintain the tree order as provided by Bhaki
i.e.
A
|
|=B
| |=E
| \=F
|
|=C
\=D
.