How to read XML file in stored procedure
I read many titles on reading an XML in a stored procedure but still can't find the answer I am looking for. (this is my first post in stackoverflow so I am sorry if I don't format it correctly)

Here is the sample XML file I need to read/parse in a stored procedure:

    <TABLENAME>
       <Fld Name="Field1">ValueInField1</Fld>
       <Fld Name="Field2">ValueInField2</Fld>
       <Fld Name="Field3">ValueInField3</Fld>
    </TABLENAME>

What I need (ideally) is to get one-row table where the column names would be Field1, Field2, Field3, and the values in these columns would be ValueInField1, ValueInField2, ValueInField3.

Is this possible? If yes, how. Thank you in advance for any suggestions.



How to read XML file in stored procedure
===

I read many titles on reading an XML in a stored procedure but still can't find the answer I am looking for. (this is my first post in stackoverflow so I am sorry if I don't format it correctly)

Here is the sample XML file I need to read/parse in a stored procedure:

    <TABLENAME>
       <Fld Name="Field1">ValueInField1</Fld>
       <Fld Name="Field2">ValueInField2</Fld>
       <Fld Name="Field3">ValueInField3</Fld>
    </TABLENAME>

What I need (ideally) is to get one-row table where the column names would be Field1, Field2, Field3, and the values in these columns would be ValueInField1, ValueInField2, ValueInField3.

Is this possible? If yes, how. Thank you in advance for any suggestions.


