Skip to content
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md
advancedTestCatTree.sql
license.txt
procMoveCatSubtree.sql
setupNsmCatTree.sql

README.md

SQL-Nested-Set-Move-Subtree

https://natethedba.wordpress.com/the-nested-set-model/

A set of sample scripts for implementing and testing the "Move Subtree" operation on a Nested Set Model table named NsmCat, as discussed in the blog post above. Includes a "setup" script (create table & fill with sample data), the "proc" script (create the stored procedure for moving a subtree), and an "advanced" script (adds Depth and Sort columns and shows how to use them to preview/verify tree structure after operations).

I ask politely for attribution if you found this helpful, but I'd settle for an upvote on SO and/or a comment/follow on my blog! Cheers.

You can’t perform that action at this time.