• 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