Production.vProductModelInstructions (view) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:06Z

Bot at 22:11, 2 February 2010

2010-02-02T22:11:00Z

Bot at 21:57, 28 December 2009

2009-12-28T21:57:11Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:10Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:22Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:49Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:35Z

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

 CREATE VIEW [Production].[vPr...

2009-01-03T12:36:41Z

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

New page

== wikibot ==

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

<pre>
CREATE VIEW [Production].[vProductModelInstructions]
AS
SELECT
[ProductModelID]
,[Name]
,[Instructions].value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
(/root/text())[1]', 'nvarchar(max)') AS [Instructions]
,[MfgInstructions].ref.value('@LocationID[1]', 'int') AS [LocationID]
,[MfgInstructions].ref.value('@SetupHours[1]', 'decimal(9, 4)') AS [SetupHours]
,[MfgInstructions].ref.value('@MachineHours[1]', 'decimal(9, 4)') AS [MachineHours]
,[MfgInstructions].ref.value('@LaborHours[1]', 'decimal(9, 4)') AS [LaborHours]
,[MfgInstructions].ref.value('@LotSize[1]', 'int') AS [LotSize]
,[Steps].ref.value('string(.)[1]', 'nvarchar(1024)') AS [Step]
,[rowguid]
,[ModifiedDate]
FROM [Production].[ProductModel]
CROSS APPLY [Instructions].nodes(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
/root/Location') MfgInstructions(ref)
CROSS APPLY [MfgInstructions].ref.nodes('declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
step') Steps(ref);
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | Production.vProductModelInstructions
@@ Line 8: / Line 8: @@
 | '''Description
 | Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
 |}
 === Source ===
@@ Line 43: / Line 41: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table
 | [[Production.ProductModel_(table)|Production.ProductModel]]
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | Production.vProductModelInstructions
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE VIEW [Production].[vProductModelInstructions]
@@ Line 34: / Line 36: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 45: / Line 47: @@
 | Table
 | [[Production.ProductModel_(table)|Production.ProductModel]]
 |}

@@ Line 37: / Line 37: @@
 | Production.vProductModelInstructions
 |- valign="top"
 | '''Description
 | Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
 |-
 |}

@@ Line 71: / Line 71: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[Production.ProductModel_(table)|Production.ProductModel]]
-| Table
 |-
 | Schema
 | Schema
 |}

@@ Line 30: / Line 30: @@
      step') Steps(ref);
 </pre>
 == automatically generated ==
@@ Line 37: / Line 36: @@
 | '''view
 | Production.vProductModelInstructions
-|-
+|- valign="top"
 | '''Description
@@ Line 75: / Line 74: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[Production.ProductModel_(table)|Production.ProductModel]]
 | Table
 | Select
 |}

← Older revision		Revision as of 22:59, 26 November 2009
Line 30:		Line 30:
	step') Steps(ref);		step') Steps(ref);
	</pre>		</pre>
		+
		+	== automatically generated ==
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|-
		+	\| '''view
		+	\| Production.vProductModelInstructions
		+	\|-
		+
		+	\| '''Description
		+	\| Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
		+	\|-
		+
		+	\|}
		+
		+	<pre>
		+
		+	CREATE VIEW [Production].[vProductModelInstructions]
		+	AS
		+	SELECT
		+	[ProductModelID]
		+	,[Name]
		+	,[Instructions].value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
		+	(/root/text())[1]', 'nvarchar(max)') AS [Instructions]
		+	,[MfgInstructions].ref.value('@LocationID[1]', 'int') AS [LocationID]
		+	,[MfgInstructions].ref.value('@SetupHours[1]', 'decimal(9, 4)') AS [SetupHours]
		+	,[MfgInstructions].ref.value('@MachineHours[1]', 'decimal(9, 4)') AS [MachineHours]
		+	,[MfgInstructions].ref.value('@LaborHours[1]', 'decimal(9, 4)') AS [LaborHours]
		+	,[MfgInstructions].ref.value('@LotSize[1]', 'int') AS [LotSize]
		+	,[Steps].ref.value('string(.)[1]', 'nvarchar(1024)') AS [Step]
		+	,[rowguid]
		+	,[ModifiedDate]
		+	FROM [Production].[ProductModel]
		+	CROSS APPLY [Instructions].nodes(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
		+	/root/Location') MfgInstructions(ref)
		+	CROSS APPLY [MfgInstructions].ref.nodes('declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
		+	step') Steps(ref);
		+	</pre>
		+
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|- style="background:silver"
		+	\| '''Referenced Object
		+	\| '''Object Type
		+	\| '''Dependency Type
		+
		+	\|-
		+	\| [[Production.ProductModel_(table)\|Production.ProductModel]]
		+	\| Table
		+	\| Select
		+	\|}