Generated using SQL Data Dictionary demo version.

Procedure dbo.uspGetManagerEmployees

Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.

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


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