Views | SQL 2005 Adventure Works OLTP |
Properties
Transactional Uses cursors Executes procedures Dynamic content Encrypted No No No No No
Data Source Activity
Accesses Description EMP_cte HumanResources.Employee Employee information such as salary, department, and title. Person.Contact Names of each employee, customer contact, and vendor contact.
Output Recordset
Column Description EmployeeID ManagerID FirstName LastName RecursionLevel
Data source Description EMP_cte HumanResources.Employee Employee information such as salary, department, and title. Person.Contact Names of each employee, customer contact, and vendor contact.
Accessed by
Name Description dbo.uspGetManagerEmployees Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.
Applies to
Views | Table expressions