dbo.uspGetEmployeeManagers

Procedure/Function: 'dbo.uspGetEmployeeManagers', Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.

Procedure Name	Description	Parameters
dbo.uspGetEmployeeManagers	Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.	@RETURN_VALUE int(10) [RETURN VALUE], @EmployeeID int(10) [INPUT]

Dependencies for Procedure/Function 'dbo.uspGetEmployeeManagers', 7 items

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
HumanResources.Employee	user table	Title