Home > IT Answers > SQL Server > How to convert XML data into tabular form in SQL Server 2005
Shama
5 pts.
 How to convert XML data into tabular form in SQL Server 2005
SQL Server, SQL Server 2005, XML, XML development, XML File Creation
Hi,

I have a concatenated string of XML data.

I need to convert the string into tabular form.

Please suggest how it can be done.

Thanks in advance!



Software/Hardware used:
SQL Server 2005
ASKED: November 25, 2010  12:02 PM
UPDATED: November 29, 2010  2:14 PM
RELATED QUESTIONS
Answer Wiki:
You will want to use OPENXML. I talk about using OPENXML in a <a href="http://itknowledgeexchange.techtarget.com/sql-server/openxml-can-be-a-beast-sometimes/">blog post</a>.
Last Wiki Answer Submitted:  November 28, 2010  6:48 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _