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 |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2001-09-18 : 12:50:49
|
| I am a procedure that builds an XML menu based on a users group membership and sec_level within that group.The Menu table looks like thisLinkID | ParentID | MenuGroupID | GroupID | SecLevel | Name | LinkThe Group Table Looks LikeGroupID | UserID | SecLevelMenuGroup tableMenuGroupID | MenuGroupNameThe Proc would take the the UserID and build the menu.THe way it looks to me is i'll need a while loop to select the tree for each MenuGroup for each group the User belongs to. I am having trouble on how to build the recursive menu in this manner. After i get the menu in order i can then select it as an XML doc with for XML Explicit. Might any of you fine folk have any insight?Thanks Christian-=:SpasmatiK:=- |
|
|
|
|
|
Dynamic Tree Menu