Views | SQL 2005 Adventure Works OLTP |
Uses PIVOT to return aggregated sales information for each sales representative.
Properties
Transactional Uses cursors Executes procedures Dynamic content Encrypted No No No No No
Data Source Activity
Accesses Description HumanResources.Employee Employee information such as salary, department, and title. Person.Contact Names of each employee, customer contact, and vendor contact. Sales.SalesOrderHeader General sales order information. Sales.SalesPerson Sales representative current information. Sales.SalesTerritory Sales territory lookup table.
Output Recordset
Column Description SalesPersonID FullName Title SalesTerritory 2002 2003 2004
Data source Description HumanResources.Employee Employee information such as salary, department, and title. Person.Contact Names of each employee, customer contact, and vendor contact. Sales.SalesOrderHeader General sales order information. Sales.SalesPerson Sales representative current information. Sales.SalesTerritory Sales territory lookup table.
Applies to
Views