Generated using SQL Data Dictionary demo version.
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 |