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.

Result:


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)

Uses: