Generated using SQL Data Dictionary demo version.

Procedure dbo.uspGetEmployeeManagers

Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.

Parameter Data Type Default Is Output
@BusinessEntityID int
Input parameter for the stored procedure uspGetEmployeeManagers. Enter a valid BusinessEntityID from the HumanResources.Employee table.


Column Data Type Nullable
RecursionLevel int X
BusinessEntityID int X
FirstName nvarchar(50) X
LastName nvarchar(50) X
OrganizationNode nvarchar(4000) X
ManagerFirstName nvarchar(50)
ManagerLastName nvarchar(50)