Listing 4: Query That Returns Subordinates of Employees 2 and 5

SELECT 
  M.EmployeeID AS mgrid,
  M.FirstName + ' ' + M.LastName AS mgrname,
  E.*
FROM dbo.Employees AS M
  CROSS APPLY dbo.fn_getsubtree(M.EmployeeID) AS E
WHERE M.EmployeeID IN(2, 5);