One more try -

WITH DirectReports AS

(

SELECT

e.ManagerID

,e.EmployeeID

,e.Title

,0 AS LEVEL

,cast(e.ManagerID AS varchar(MAX)) AS [path]

FROM dbo.MyEmployees AS e

WHERE ManagerID IS NULL

UNION ALL

SELECT

e.ManagerID

,e.EmployeeID

,e.Title

,LEVEL + 1

,cast(cast(e.ManagerID...

If I understand the question - this should get you a path - you may want to modify the ordering etc.

WITH DirectReports AS

(

SELECT

e.ManagerID

,e.EmployeeID

,e.Title

,0 AS LEVEL

,cast(e.ManagerID...