I have a system that was developed that put an XML document inside a Column,
I am looking for recommendations, samples, etc. on the best way to process
this column, if possible in a T-SQL Statement, else a Stored-Procedure.

Example Record:

ID Type Message
1 1 <?xml version="1.0"
encoding="UTF-8"?><ENTRY_TYPE1><FieldName="Type"><![CDATA[Type1]]></field><F
ieldName="Description"><![CDATA[Description of Type
1]]></field></ENTRY_TYPE1>
2 1 <?xml version="1.0"
encoding="UTF-8"?><ENTRY_TYPE1><FieldName="Type"><![CDATA[Type1]]></field><F
ieldName="Description"><![CDATA[This is another Description of Type
1]]></field></ENTRY_TYPE1>


What I would like is a Result Type of:

ID Type Description
1 Type1 Description of Type 1
2 Type1 This is another Description of Type 1

Any suggestions on the best way to do this?
This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged.
The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be
aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received
this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.


MS Sql Server LazyDBA home page