Recursive Data
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi ALL, I have a table where data is stored in a Hierarchical manner. For example User1 supervise User2 and User3 User 2 supervises User3 and User4... How can I loop through the hierarchy get all users supervised by user1 dynamically? That is in the example above (User1, 2, 3 and 4)?
-
Hi ALL, I have a table where data is stored in a Hierarchical manner. For example User1 supervise User2 and User3 User 2 supervises User3 and User4... How can I loop through the hierarchy get all users supervised by user1 dynamically? That is in the example above (User1, 2, 3 and 4)?
Is User3 supervised by multiple people (User1 and User2) or that is just a typo? Damodar Periwal Software Tree, Inc. Simplify Data Integration http://www.softwaretree.com