>Hi,
>
>I am "translating" my VFP stored procedure into a SQL Server stored procedure. The VFP stored procedure receives a couple of small XML files (as strings) and then "deals" with them. How do I convert an XML string file inside SQL Server stored procedure into a temp table? I think that once I have the XML in the temp file I can go on with processing it. Or if you have any other suggestion on how to make an XML string inside SQL Stored procedure as a series of variables, please let me know.
>
>TIA.

So far the examples I see online for selecting values from an XML are different from my "version" of XML. Here is an example of what my XML look like:

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

Anybody knows the t-sql syntax to parse this type of XML? That is, how to get values?

Thank you.