Person.vStateProvinceCountryRegion (view) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:26Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:48Z

Bot at 21:57, 28 December 2009

2009-12-28T21:57:16Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:55Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:06Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:33Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:40Z

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

 CREATE VIEW [Person].[vStatePro...

2009-01-03T12:36:45Z

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

New page

== wikibot ==

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

<pre>
CREATE VIEW [Person].[vStateProvinceCountryRegion]
WITH SCHEMABINDING
AS
SELECT
sp.[StateProvinceID]
,sp.[StateProvinceCode]
,sp.[IsOnlyStateProvinceFlag]
,sp.[Name] AS [StateProvinceName]
,sp.[TerritoryID]
,cr.[CountryRegionCode]
,cr.[Name] AS [CountryRegionName]
FROM [Person].[StateProvince] sp
INNER JOIN [Person].[CountryRegion] cr
ON sp.[CountryRegionCode] = cr.[CountryRegionCode];
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | Person.vStateProvinceCountryRegion
@@ Line 8: / Line 8: @@
 | '''Description
 | Joins StateProvince table with CountryRegion table.
 |}
 === Source ===
@@ Line 37: / Line 35: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.CountryRegion_(table)|Person.CountryRegion]]
-|-
+|- valign="top"
 | Select
 | Table
 | [[Person.StateProvince_(table)|Person.StateProvince]]
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | Person.vStateProvinceCountryRegion
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE VIEW [Person].[vStateProvinceCountryRegion]
@@ Line 28: / Line 30: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 44: / Line 46: @@
 | Table
 | [[Person.StateProvince_(table)|Person.StateProvince]]
 |}

@@ Line 31: / Line 31: @@
 | Person.vStateProvinceCountryRegion
 |- valign="top"
 | '''Description
 | Joins StateProvince table with CountryRegion table.
 |-
 |}

@@ Line 59: / Line 59: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[Person.CountryRegion_(table)|Person.CountryRegion]]
 | Table
 | [[Person.StateProvince_(table)|Person.StateProvince]]
-| Table
 |-
 | Schema
 | Schema
 |}

@@ Line 24: / Line 24: @@
      ON sp.[CountryRegionCode] = cr.[CountryRegionCode];
 </pre>
 == automatically generated ==
@@ Line 31: / Line 30: @@
 | '''view
 | Person.vStateProvinceCountryRegion
-|-
+|- valign="top"
 | '''Description
@@ Line 63: / Line 62: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[Person.CountryRegion_(table)|Person.CountryRegion]]
@@ Line 72: / Line 71: @@
 | Table
 | Select
 |}

← Older revision		Revision as of 22:59, 26 November 2009
Line 24:		Line 24:
	ON sp.[CountryRegionCode] = cr.[CountryRegionCode];		ON sp.[CountryRegionCode] = cr.[CountryRegionCode];
	</pre>		</pre>
		+
		+	== automatically generated ==
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|-
		+	\| '''view
		+	\| Person.vStateProvinceCountryRegion
		+	\|-
		+
		+	\| '''Description
		+	\| Joins StateProvince table with CountryRegion table.
		+	\|-
		+
		+	\|}
		+
		+	<pre>
		+
		+	CREATE VIEW [Person].[vStateProvinceCountryRegion]
		+	WITH SCHEMABINDING
		+	AS
		+	SELECT
		+	sp.[StateProvinceID]
		+	,sp.[StateProvinceCode]
		+	,sp.[IsOnlyStateProvinceFlag]
		+	,sp.[Name] AS [StateProvinceName]
		+	,sp.[TerritoryID]
		+	,cr.[CountryRegionCode]
		+	,cr.[Name] AS [CountryRegionName]
		+	FROM [Person].[StateProvince] sp
		+	INNER JOIN [Person].[CountryRegion] cr
		+	ON sp.[CountryRegionCode] = cr.[CountryRegionCode];
		+	</pre>
		+
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|- style="background:silver"
		+	\| '''Referenced Object
		+	\| '''Object Type
		+	\| '''Dependency Type
		+
		+	\|-
		+	\| [[Person.CountryRegion_(table)\|Person.CountryRegion]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Person.StateProvince_(table)\|Person.StateProvince]]
		+	\| Table
		+	\| Select
		+	\|}