Sales.vIndividualCustomer (view) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:59Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:31Z

Bot at 21:57, 28 December 2009

2009-12-28T21:57:01Z

Bot at 06:02, 30 November 2009

2009-11-30T06:02:01Z

Bot at 05:40, 30 November 2009

2009-11-30T05:40:14Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:40Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:23Z

Bot at 22:28, 26 November 2009

2009-11-26T22:28:31Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | Sales.vIndividualCustomer |- |}

 CREATE VIEW [Sales].[vIndividualCustomer...

2009-01-03T12:36:31Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | Sales.vIndividualCustomer |- |} <pre> CREATE VIEW [Sales].[vIndividualCustomer...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''view
| Sales.vIndividualCustomer
|-
|}

<pre>
CREATE VIEW [Sales].[vIndividualCustomer]
AS
SELECT
i.[CustomerID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,at.[Name] AS [AddressType]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,[StateProvinceName] = sp.[Name]
,a.[PostalCode]
,[CountryRegionName] = cr.[Name]
,i.[Demographics]
FROM [Sales].[Individual] i
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = i.[ContactID]
INNER JOIN [Sales].[CustomerAddress] ca
ON ca.[CustomerID] = i.[CustomerID]
INNER JOIN [Person].[Address] a
ON a.[AddressID] = ca.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
INNER JOIN [Person].[CountryRegion] cr
ON cr.[CountryRegionCode] = sp.[CountryRegionCode]
INNER JOIN [Person].[AddressType] at
ON ca.[AddressTypeID] = at.[AddressTypeID]
WHERE i.[CustomerID] IN (SELECT [Sales].[Customer].[CustomerID]
FROM [Sales].[Customer] WHERE UPPER([Sales].[Customer].[CustomerType]) = 'I');
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | Sales.vIndividualCustomer
@@ Line 8: / Line 8: @@
 | '''Description
 | Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
 |}
 === Source ===
@@ Line 58: / Line 56: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.Address_(table)|Person.Address]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.AddressType_(table)|Person.AddressType]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.Contact_(table)|Person.Contact]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.CountryRegion_(table)|Person.CountryRegion]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.StateProvince_(table)|Person.StateProvince]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Sales.Customer_(table)|Sales.Customer]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Sales.Individual_(table)|Sales.Individual]]
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | Sales.vIndividualCustomer
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE VIEW [Sales].[vIndividualCustomer]
@@ Line 49: / Line 51: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 95: / Line 97: @@
 | Table
 | [[Sales.Individual_(table)|Sales.Individual]]
 |}

@@ Line 52: / Line 52: @@
 | Sales.vIndividualCustomer
 |- valign="top"
 | '''Description
 | Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
 |-
 |}

@@ Line 101: / Line 101: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[Person.Address_(table)|Person.Address]]
 | Table
 | Select
 |-
-| [[Person.AddressType_(table)|Person.AddressType]]
+| Select
 | Table
 | Select
 |-
-| [[Person.Contact_(table)|Person.Contact]]
+| Select
 | Table
-| Select
+| [[Sales.Customer_(table)|Sales.Customer]]
 |-
 | Select
 | Table
-| Select
+| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 |-
 | Select
 | Table
 | [[Sales.Individual_(table)|Sales.Individual]]
-| Table
 |-
 | Schema
 | Schema
 |}

@@ Line 51: / Line 51: @@
 | '''view
 | Sales.vIndividualCustomer
-|-
+|- valign="top"
 | '''Description
@@ Line 104: / Line 104: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[Person.Address_(table)|Person.Address]]
@@ Line 137: / Line 137: @@
 | Table
 | Select
 |}

@@ Line 5: / Line 5: @@
 | '''view
 | Sales.vIndividualCustomer
 |-
 |}
@@ Line 45: / Line 48: @@
      FROM [Sales].[Customer] WHERE UPPER([Sales].[Customer].[CustomerType]) = 'I');
 </pre>
 == automatically generated ==