dbo.uspGetManagerEmployees

Procedure/Function: 'dbo.uspGetManagerEmployees', Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.

Procedure NameDescriptionParameters
dbo.uspGetManagerEmployeesStored 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]

Dependencies for Procedure/Function 'dbo.uspGetManagerEmployees', 6 items

Object NameTypeField Name
Person.Contactuser tableContactID
Person.Contactuser tableFirstName
Person.Contactuser tableLastName
HumanResources.Employeeuser tableEmployeeID
HumanResources.Employeeuser tableContactID
HumanResources.Employeeuser tableManagerID