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-17 : 15:43:00
|
Paul writes "SQL Server 6.5
Im using a Tree Data Strucure in my database, basically I have a database table that looks like the following:
Nodes
NodeID int,
XRefID int,
ParentID int
The XrefID is for referencing whatever data is associated with that node. Anyhow, while trying to write several trivial functions like copynode, deletenode, movenode, recursion is necessary(at least in my opinion) to traverse the tree and copy or move the node and all of it's children. SQL Server 6.5 seems to have problems doing recursion beyond 16 levels. Got any suggestions for this one?
It seems like if I want to perform the functions on the database side I need to upgrade to 7.0 which allows for recursion further then 16 levels... maybe Im wrong though.
Regards,
Paul"
|
|
|
|
|
|
SQL Server 6.5 and Tree Data Structures