Hello all,

Please see the filter I have provided on the SFARBE column in the WITH block. This avoids including blank strings.

SELECT SFARBE,RREFERENZ FROM OPENXML (@idoc, 'FARBE' ,1)

WITH ( SFARBE...

Mike, this should do the trick. OPENXML method first followed by the .nodes() method.

declare @xml xml

set @xml = '<Products>

<Product ID="123" Name="Male Bicycle" Amount="1">

...

@mike-2: provide me an example of your XML and what you want, and I can write it up for you in both OPENXML and .nodes methods.

-Graham

Using OPENXML vs. .nodes is a trade off situation, each with good use cases.

You have to start by asking yourself what you want: performance or resource constraints. If you...

Gary,

I would think XML indexes are only useful across multiple rows, like when you want to find rows that contain certain data in the XML or when the XML column...

How about using OPENXML?

DECLARE @idoc int, @myXml xml

SET @myXml = '<Author xmlns:xsi="..." xmlns:xsd="..." version="1">

<Benefits>

<Benefit Name="HospitalizationLimit" Value="500000"/>

<Benefit Name="MedicalConsultationLimit" Value="12000"/>

...