SELECT EmployeeID AS [Direct Reports]
FROM dbo.AWEmpTree(140)
WHERE depth = 1
SELECT COUNT(*) - 1 [Number of Reports]
FROM dbo.AWEmpTree(140)
a
b
