Sales.vSalesPerson (view) - Revision history

Bot at 22:18, 23 June 2010

2010-06-23T22:18:02Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:30Z

Bot at 21:57, 28 December 2009

2009-12-28T21:57:13Z

Bot at 06:02, 30 November 2009

2009-11-30T06:02:00Z

Bot at 05:40, 30 November 2009

2009-11-30T05:40:13Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:38Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:37Z

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

 CREATE VIEW [Sales].[vSalesPerson]  AS  SELECT ...

2009-01-03T12:36:42Z

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

New page

== wikibot ==

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

<pre>
CREATE VIEW [Sales].[vSalesPerson]
AS
SELECT
s.[SalesPersonID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,[JobTitle] = e.[Title]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,[StateProvinceName] = sp.[Name]
,a.[PostalCode]
,[CountryRegionName] = cr.[Name]
,[TerritoryName] = st.[Name]
,[TerritoryGroup] = st.[Group]
,s.[SalesQuota]
,s.[SalesYTD]
,s.[SalesLastYear]
FROM [Sales].[SalesPerson] s
INNER JOIN [HumanResources].[Employee] e
ON e.[EmployeeID] = s.[SalesPersonID]
LEFT OUTER JOIN [Sales].[SalesTerritory] st
ON st.[TerritoryID] = s.[TerritoryID]
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
INNER JOIN [HumanResources].[EmployeeAddress] ea
ON e.[EmployeeID] = ea.[EmployeeID]
INNER JOIN [Person].[Address] a
ON ea.[AddressID] = a.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
INNER JOIN [Person].[CountryRegion] cr
ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | Sales.vSalesPerson
@@ Line 8: / Line 8: @@
 | '''Description
 | Sales representiatives (names and addresses) and their sales-related information.
 |}
 === Source ===
@@ Line 62: / Line 60: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.Address_(table)|Person.Address]]
-|-
+|- 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.SalesPerson_(table)|Sales.SalesPerson]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | Sales.vSalesPerson
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE VIEW [Sales].[vSalesPerson]
@@ Line 53: / Line 55: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 99: / Line 101: @@
 | Table
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 |}

@@ Line 56: / Line 56: @@
 | Sales.vSalesPerson
 |- valign="top"
 | '''Description
 | Sales representiatives (names and addresses) and their sales-related information.
 |-
 |}

@@ Line 109: / Line 109: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
 | Table
 | Select
 |-
-| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
+| Select
 | Table
 | Select
 |-
-| [[Person.Address_(table)|Person.Address]]
+| Select
 | Table
-| Select
+| [[Person.StateProvince_(table)|Person.StateProvince]]
 |-
 | Select
 | Table
-| Select
+| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 |-
 | Select
 | Table
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
-| Table
 |-
 | Schema
 | Schema
 |}

@@ Line 49: / Line 49: @@
      ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
 </pre>
 == automatically generated ==
@@ Line 56: / Line 55: @@
 | '''view
 | Sales.vSalesPerson
-|-
+|- valign="top"
 | '''Description
@@ Line 113: / Line 112: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
@@ Line 146: / Line 145: @@
 | Table
 | Select
 |}

← Older revision		Revision as of 22:59, 26 November 2009
Line 49:		Line 49:
	ON cr.[CountryRegionCode] = sp.[CountryRegionCode];		ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
	</pre>		</pre>
		+
		+	== automatically generated ==
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|-
		+	\| '''view
		+	\| Sales.vSalesPerson
		+	\|-
		+
		+	\| '''Description
		+	\| Sales representiatives (names and addresses) and their sales-related information.
		+	\|-
		+
		+	\|}
		+
		+	<pre>
		+
		+	CREATE VIEW [Sales].[vSalesPerson]
		+	AS
		+	SELECT
		+	s.[SalesPersonID]
		+	,c.[Title]
		+	,c.[FirstName]
		+	,c.[MiddleName]
		+	,c.[LastName]
		+	,c.[Suffix]
		+	,[JobTitle] = e.[Title]
		+	,c.[Phone]
		+	,c.[EmailAddress]
		+	,c.[EmailPromotion]
		+	,a.[AddressLine1]
		+	,a.[AddressLine2]
		+	,a.[City]
		+	,[StateProvinceName] = sp.[Name]
		+	,a.[PostalCode]
		+	,[CountryRegionName] = cr.[Name]
		+	,[TerritoryName] = st.[Name]
		+	,[TerritoryGroup] = st.[Group]
		+	,s.[SalesQuota]
		+	,s.[SalesYTD]
		+	,s.[SalesLastYear]
		+	FROM [Sales].[SalesPerson] s
		+	INNER JOIN [HumanResources].[Employee] e
		+	ON e.[EmployeeID] = s.[SalesPersonID]
		+	LEFT OUTER JOIN [Sales].[SalesTerritory] st
		+	ON st.[TerritoryID] = s.[TerritoryID]
		+	INNER JOIN [Person].[Contact] c
		+	ON c.[ContactID] = e.[ContactID]
		+	INNER JOIN [HumanResources].[EmployeeAddress] ea
		+	ON e.[EmployeeID] = ea.[EmployeeID]
		+	INNER JOIN [Person].[Address] a
		+	ON ea.[AddressID] = a.[AddressID]
		+	INNER JOIN [Person].[StateProvince] sp
		+	ON sp.[StateProvinceID] = a.[StateProvinceID]
		+	INNER JOIN [Person].[CountryRegion] cr
		+	ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
		+	</pre>
		+
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|- style="background:silver"
		+	\| '''Referenced Object
		+	\| '''Object Type
		+	\| '''Dependency Type
		+
		+	\|-
		+	\| [[HumanResources.Employee_(table)\|HumanResources.Employee]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[HumanResources.EmployeeAddress_(table)\|HumanResources.EmployeeAddress]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Person.Address_(table)\|Person.Address]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Person.Contact_(table)\|Person.Contact]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Person.CountryRegion_(table)\|Person.CountryRegion]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Person.StateProvince_(table)\|Person.StateProvince]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Sales.SalesPerson_(table)\|Sales.SalesPerson]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Sales.SalesTerritory_(table)\|Sales.SalesTerritory]]
		+	\| Table
		+	\| Select
		+	\|}