--ID--------EMPNAME--------MANAGERID
--__________________________________
--1------------A-------------NULL 
--2------------B--------------1
--3------------C--------------4
--4------------D--------------2
--5------------E--------------3
--6------------F--------------5
declare @sample table(id int, empname varchar(255), managerid int)
insert @sample
select 1,'A',NULL union all
select 2,'B',1 union all
select 3,'C',4 union all
select 4,'D',2 union all
select 5,'E',3 union all
select 6,'F',5

--select * from @sample

;WITH cte (managerid,id,empname)
AS
(
-- Anchor member definition
    SELECT e.ManagerID, e.ID, e.empname
    FROM @sample as e
    WHERE ManagerID IS NULL
    UNION ALL
-- Recursive member definition
    SELECT e.ManagerID, e.ID, e.empname
    FROM @sample as e
    INNER JOIN cte AS d
        ON e.ManagerID = d.ID
)

select id,empname,managerid from cte