Although it is a good example but too many unnecessary JOINS has messed the whole concept. I can achieve the same result with WITH DirectReports (ManagerID, EmployeeID, Title, DeptID, Level)(-- Anchor member definition SELECT e.ManagerID, e.Emp...