T-SQL recursive query

Querying a recursive hierarchy using a CTE: (SQL CTE recursion)

1  withCte_ma as 2 (3     SELECT 0  asTier, EmployeeID, ManagerID, FirstName, LastName4      fromdbo. MyEmployees5     WHEREEmployeeID= 16     UNION  All7     SELECTA.tier+1  asTier, E.employeeid, E.managerid, E.firstname, E.lastname8      fromdbo. MyEmployees e9     INNER JOINCte_ma A onE.managerid=A.employeeidTen ) One SELECT *  fromCte_ma

Tier        EmployeeID managerid   FirstName                      LastName------------------------------------------------------- -----------------------------------------------0           1          NULL        Ken                            sánchez1           273        1           Brian                          Welcker2         273         David                          Bradley2           274        273         Stephen                        Jiang2           285        273         Syed                           Abbas3           286        285         Lynn                           Tsoflias3           275        274         Michael                        Blythe3           276        274         Linda                          Mitchell3           ,          Mary                           Gibson

T-SQL recursive query