Thanks Srinivas,
Very good description of recursive common table expressions and great sample for getting hierarchical data with a defined value of drill down levels (sample 1).
I liked the sample 1. I believe it will be very useful for many of us.
Eralper