I have 'employee' table which has EmployeeID and SupervisorID (self-join) and I join the table to fact table using Username field as the fact table doesn't have EmployeeID.
I would like to build Employee hierarchy and I have two questions:
1) What is the standard way of doing that? I presume this is rather very common.
2) How can build hierarchy so it appear on multiple levels.... like Tree view?
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!