| Procedure Name | Description | Parameters |
|---|---|---|
| dbo.uspGetManagerEmployees | Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. | @RETURN_VALUE int(10) [RETURN VALUE], @ManagerID int(10) [INPUT] |
| Object Name | Type | Field Name |
|---|---|---|
| Person.Contact | user table | ContactID |
| Person.Contact | user table | FirstName |
| Person.Contact | user table | LastName |
| HumanResources.Employee | user table | EmployeeID |
| HumanResources.Employee | user table | ContactID |
| HumanResources.Employee | user table | ManagerID |