Question regarding tree to show recursive data structure

[enchev]

You want top -> down structure, right? Northwind Employees is a self-referencing table as well, here is how to display it:

1. First get the employees not reporting to anyone and use it for first level:
   

   
   
   
   

2. Then get the employees reporting to expanded employee:
   

   
   
   
   

Here is how it looks runtime: