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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-19 : 17:54:22
|
Laurent writes "i have an applet that show a tree menu, i would like that the content of the menu comes out of an SQL table, i have then made one and there is four columns :
the first with the id of each row
the second with the level rangin' from the root to the most away leaf (1 for the root level)
the third with the id of the parent (the value for the root is thus 0)
the last with the label that will appear inb the applet.
Should you show me what kind of select or stored procedure would i have to use to automatically sort my table and specify the depth of the request and thus of the result ?" |
|
|
|
|
|
Tree menu