Databases > AdventureWorks2019 > Stored Procedures > uspGetManagerEmployees

AdventureWorks2019

uspGetManagerEmployees

//

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

Created: 5/8/2023 Modified: 5/8/2023

Parameters

//

Input parameter for the stored procedure uspGetManagerEmployees. Enter a valid BusinessEntityID of the manager from the HumanResources.Employee table.

@BusinessEntityID

[int] NULL

Definition