xml query to table - xquery problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

xml query to table - xquery problem

Author

Topic

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-12-07 : 07:33:31

[code]
<filter id="1">
<PRODUCT DataType="integer" Operator="EQUAL">
<attrib Name="OEM" Operator="LIST" value="6,110">
<attrib Name="North Hills" DataType="integer" value="6">
<attrib Name="OEM1" DataType="string" value="ju" />
</attrib>
<attrib Name="Hyundai" DataType="integer" value="110">
<attrib Name="OEM1" DataType="string" value="ys" />
<attrib Name="OEM2" DataType="string" value="se 33333" />
<attrib Name="OEM3" DataType="string" value="trt" />
<attrib Name="OEM4" DataType="string" value="tt" />
</attrib>
</attrib>
</PRODUCT>
</filter>

<filter id="2">
<PRODUCT DataType="integer" Operator="EQUAL">
<attrib Name="OEM" Operator="LIST" value="9,563">
<attrib Name="test 2" DataType="integer" value="9">
<attrib Name="OEM1" DataType="string" value="s88test" />
</attrib>
<attrib Name="test 3" DataType="integer" value="563">
<attrib Name="OEM1" DataType="string" value="serrr" />
<attrib Name="OEM2" DataType="string" value="255" />
</attrib>
</attrib>
</PRODUCT>
</filter>

Output like..
filterid ManufacturerID OEM1 OEM2 OEM3 OEM4
1 6 ju
1 110 ys se 33333 trt tt
2 9 s88test
2 563 serrr 255
[/code]

I need each oem against that manufacturer in row filter wise from xml...
Please help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources