John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
Microsoft SQL Server
Given the following sql data, how do I select this hierarchically to produce a list with the parents/children in the proper order (children ordered by rightsorder)?
Looks like you are using a reflexive table todefine the hierarchy, right? You would probabaly be better off to separate the data from the structure of the hierarchy.
You can download the white paper and code samples from the tools and utilities page of my web site from my conference presentation entitled "Modeling Hierarchies". The sample are all VFP, but it gives you the concepts.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only