|
vEmployee
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
17 |
945 |
0 |
8 |
2,147,485,886 b |
Employee names and addresses.
|
|
vEmployeeDepartment
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
10 |
691 |
0 |
5 |
1,284 b |
Returns employee name, title, and current department.
|
|
vEmployeeDepartmentHistory
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
11 |
714 |
0 |
6 |
1,292 b |
Returns employee name and current and previous departments.
|
|
vJobCandidate
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
16 |
3,095 |
0 |
1 |
6,442,452,957 b |
Job candidate names and resumes.
|
|
vJobCandidateEducation
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
13 |
2,866 |
0 |
1 |
2,147,485,907 b |
Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
|
|
vJobCandidateEmployment
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
11 |
2,558 |
0 |
1 |
12,884,902,702 b |
Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
|
|
vAdditionalContactInfo
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
17 |
4,204 |
0 |
2 |
6,442,453,481 b |
Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.
|
|
vStateProvinceCountryRegion
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
7 |
453 |
1 |
4 |
432 b |
Joins StateProvince table with CountryRegion table.
|
|
vProductAndDescription
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
5 |
670 |
1 |
5 |
2,028 b |
Product names and descriptions. Product descriptions are provided in multiple languages.
|
|
vProductModelCatalogDescription
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
25 |
6,422 |
0 |
2 |
6,442,471,769 b |
Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
|
|
vProductModelInstructions
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
11 |
1,287 |
0 |
2 |
2,147,487,994 b |
Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
|
|
vVendor
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
17 |
1,077 |
0 |
10 |
2,440 b |
Vendor (company) names and addresses and the names of vendor employees to contact.
|
|
vIndividualCustomer
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
17 |
1,158 |
0 |
10 |
2,147,485,886 b |
Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
|
|
vIndividualDemographics
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
13 |
3,080 |
0 |
1 |
409 b |
Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.
|
|
vSalesPerson
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
21 |
1,215 |
0 |
10 |
2,664 b |
Sales representiatives (names and addresses) and their sales-related information.
|
|
vSalesPersonSalesByFiscalYears
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
7 |
1,041 |
0 |
6 |
1,036 b |
Uses PIVOT to return aggregated sales information for each sales representative.
|
|
vStoreWithDemographics
|
Mar 19 2009 9:08PM |
Mar 19 2009 9:08PM |
28 |
3,508 |
0 |
12 |
3,328 b |
Stores (names and addresses) that sell Adventure Works Cycles products to consumers.
|
