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 |