Prev: group totals w/criteria?
Next: Updating DSV Deletes All named Queries
From: CJ on 21 Apr 2010 08:20
I have an XML document that looks like the following:

<record>
<Field1>value1</Field1>
<Field2>value2</Field2>
<Field3>value3</Field3>
</record>

What I'm aiming to do is to show the data in a report as in the following
example:

record:
Field1 value1
Field2 value2
Field3 value3

The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second column the
element value. How can I achieve this?

I'm primarely interested in the SQL script.
 | 
Pages: 1
Prev: group totals w/criteria?
Next: Updating DSV Deletes All named Queries