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 Title 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.uspGetEmployeeManagers Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.
Applies to
Views | Table expressions