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 - 2000-09-08 : 22:00:33
|
Mikael writes: "Hallo SQL programmers. I'd like to hear if any one have some experience with recursive SQL. I have a table with these cols: ID, name, parent_ID. It's like a tree structure.
Lets take an example: I want to know which children there are for a given ID in the database.
What can I do? Is it possible to write a recursive stored procedure and if this is the right way to do it it would nice to see an example.
THANKS
Mikael" |
|
|
|
|
|
How to program recursive sql statements?