Hello All, I have already provided the Cursor(sort of DDL) which are creating the tree view. Also i tried to provide the tree view result of cursor.Thank you re write in recursive way to handle the tree view.Answer to Jason question, User information is define in single table,which include user name, user id ,approver id ,Role .Rule which I need to define here

1) Super Admin can add any user at any node level.First it will scan whether userid is exist or not then new add new user.

2) In case of absent of user, another user(same level or any different level user) will perform his/her role activity

3) Once user will come back then user will insert in same role

4) Admin can delete any user (in case of user leave the org) and corresponding child node will assign to another user.

These are above rule need to implement.Please help me in this.

Thanks

Rohit