I have a parent child table that stores managers and employees respectively. I can get the table to show a child and its direct parent but not the child with every ancestor( parent and grandparent). I want to get it to look like as referenced in here in the Security Associations Table: http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003086341.htm (under
Representations of an Organizational Hierarchy ).
The hierchy is unbalanced and any node can get any deep at any time.