Mehdi
Reputation: 5597
Traversing a Parent / Child Table?
I have a Self-join(parent/child) table that forms a TreeView control. in this structure only leaf nodes has a [Percent] value(persists in table only for leafs). and parent nodes values calculated from children(average values of children = parent [Percent] value).
How to write a procedure or function to calculate every node [Percent] values? any suggestions? i am beginner in sql and not familiar enough in sql statements and could not find any suitable article in the web. thank you!
Upvotes: 1
Views: 744
Answers (1)
Related Questions
- Using SQL to grab children where the parent & children are both in the same table
- Common Table Expression to traverse down hierarchy
- Retrieve a child and parent from sql table, given child or parent
- Querying Parent-Child relationship in a consecutive way
- Recursive SQL query to get children under the parents - SQL Server 2008
- Query for Parent Child Relationship to the top level
- sql Traversing parent child
- How to iterate through an SQL table which "parent" and child" rows are in same table
- Select parent and its children with SQL Server
- SQL: Selecting parents and their children