Thanks a lot Shrinivas for that.
I just want to make Point is that to get results in the Oracle it quite a lot Easier...
Just use START WITH clause specify who would be the Parent and Oracle takes care of all. I do agree that SS 2005 has better but Oracle is still the Best.
Hary Pank
Thanks a lot,
Hary