Object type: Data view

Sales representiatives (names and addresses) and their sales-related information.

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.
HumanResources.EmployeeAddress	Cross-reference table mapping employees to their address(es).
Person.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.
Sales.SalesPerson	Sales representative current information.
Sales.SalesTerritory	Sales territory lookup table.

Output Recordset 

Column	Description
SalesPersonID
Title
FirstName
MiddleName
LastName
Suffix
JobTitle
Phone
EmailAddress
EmailPromotion
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
TerritoryName
TerritoryGroup
SalesQuota
SalesYTD
SalesLastYear

Data source	Description
HumanResources.Employee	Employee information such as salary, department, and title.
HumanResources.EmployeeAddress	Cross-reference table mapping employees to their address(es).
Person.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.
Sales.SalesPerson	Sales representative current information.
Sales.SalesTerritory	Sales territory lookup table.

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation