|
[dbo].[RidiculousView]
|
Jul 17 2006 8:27PM |
Jul 17 2006 8:27PM |
8 |
11,202 |
0 |
29 |
2,201 b |
this view is ridiculous.
|
|
[HumanResources].[vEmployee]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
17 |
945 |
0 |
9 |
2,147,484,770 b |
Employee names and addresses.
|
|
[HumanResources].[vEmployeeDepartment]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
10 |
691 |
0 |
6 |
656 b |
Returns employee name, title, and current department.
|
|
[HumanResources].[vEmployeeDepartmentHistory]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
11 |
714 |
0 |
7 |
672 b |
Returns employee name and current and previous departments.
|
|
[HumanResources].[vJobCandidate]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
16 |
3,095 |
0 |
2 |
6,442,451,962 b |
Job candidate names and resumes.
|
|
[HumanResources].[vJobCandidateEducation]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
13 |
2,866 |
0 |
2 |
2,147,484,802 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.
|
|
[HumanResources].[vJobCandidateEmployment]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
11 |
2,558 |
0 |
2 |
12,884,902,312 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.
|
|
[Person].[vAdditionalContactInfo]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
17 |
4,204 |
0 |
3 |
6,442,452,230 b |
Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.
|
|
[Person].[vStateProvinceCountryRegion]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
7 |
453 |
0 |
5 |
221 b |
Joins StateProvince table with CountryRegion table.
|
|
[Production].[vProductAndDescription]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
5 |
670 |
0 |
6 |
1,016 b |
Product names and descriptions. Product descriptions are provided in multiple languages.
|
|
[Production].[vProductModelCatalogDescription]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
25 |
6,422 |
0 |
3 |
6,442,461,374 b |
Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
|
|
[Production].[vProductModelInstructions]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
11 |
1,287 |
0 |
3 |
2,147,485,871 b |
Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
|
|
[Purchasing].[vVendor]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
17 |
1,077 |
0 |
11 |
1,224 b |
Vendor (company) names and addresses and the names of vendor employees to contact.
|
|
[Sales].[vIndividualCustomer]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
17 |
1,158 |
0 |
11 |
2,147,484,770 b |
Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
|
|
[Sales].[vIndividualDemographics]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
13 |
3,080 |
0 |
2 |
254 b |
Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.
|
|
[Sales].[vSalesPerson]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
21 |
1,215 |
0 |
11 |
1,387 b |
Sales representiatives (names and addresses) and their sales-related information.
|
|
[Sales].[vSalesPersonSalesByFiscalYears]
|
Oct 14 2005 1:59AM |
Oct 14 2005 1:59AM |
7 |
1,041 |
0 |
7 |
571 b |
Uses PIVOT to return aggregated sales information for each sales representative.
|
|
[Sales].[vStoreWithDemographics]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
28 |
3,508 |
0 |
13 |
1,708 b |
Stores (names and addresses) that sell Adventure Works Cycles products to consumers.
|
