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.

Result:


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

Uses: