WITH EmpCTE AS
( SELECT * FROM HumanResources.Employee WHERE EmployeeID = 109

  UNION ALL
  SELECT E.* FROM HumanResources.Employee AS E JOIN EmpCTE AS M
      ON E.ManagerID = M.EmployeeID)
SELECT * FROM EmpCTE
OPTION(MAXRECURSION 3);