Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-20 : 02:01:26
|
| Dear allI am using sql server 2005 , asp.net 2.0 ,C#.I need some suggesstion on how to pass request info to new level . that is if a employee request for something mail should go its next level ie. immidiate boss(next level can be null) and at any time requested or chain of employee( immidiate boss and succesor ).Please suggest something |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-20 : 02:10:41
|
| Seems like you need to traverse hierarchy level. Look into books online for recursive CTE. Thats what you want to use for traversing multi level hierarchies recursively.And if your reqmnt is just to go to immiediate parent , then you jsut need a table with parent id and child id. |
 |
|
|
|
|
|
need some suggestion