• Thanks a lot Shrinivas for that.

    I just want to make a Point is that to get same sort of output in the Oracle is quite easier...

    Just use START WITH clause specify who would be the Parent and Oracle takes care of all. I do agree that SS 2005 is better but Oracle is still the Best.

    Hary Pank

    Thanks a lot,
    Hary