Execute the following Microsoft SQL Server T-SQL recursive script in Management Studio Query Editor to get the "immediate supervisor" organizational chart of AdventureWorks Cycles.

-- SQL recursive Common Table Expression - CTE

-- T-SQL tree processing, tree parsing

-- MSSQL organizational chart - orgchart

USE AdventureWorks;

GO

WITH cteSupervisor(ManagerID,EmployeeID,EmployeeLevel)

     AS (SELECT ManagerID,

                EmployeeID,

                EmployeeLevel = 0

         FROM   HumanResources.Employee

         WHERE  ManagerID IS NULL

         UNION ALL

         SELECT e.ManagerID,

                e.EmployeeID,

                EmployeeLevel + 1

         FROM   HumanResources.Employee e

                INNER JOIN cteSupervisor d

                  ON e.ManagerID = d.EmployeeID)

SELECT Manager = CO.LastName + ', ' + CO.FirstName,

       Employee = C.LastName + ', ' + C.FirstName,

       EmployeeLevel

FROM   cteSupervisor DR

      INNER JOIN HumanResources.Employee E

         ON DR.EmployeeID = E.EmployeeID

      INNER JOIN Person.Contact C

         ON E.ContactID = C.ContactID

      LEFT JOIN HumanResources.Employee EM

         ON DR.ManagerID = EM.EmployeeID

      LEFT JOIN Person.Contact CO

         ON EM.ContactID = CO.ContactID

GO

-- Results