Views SQL 2005 Adventure Works OLTP

EMP_cte used in procedure: dbo.uspGetEmployeeManagers

Object type: Common table expression

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
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.