SQL Server XML Extract Nodes
I am using SQL Server 2005 to Extract XML data. I would appreciate some help extracting the following XML snippet? <ELEMENT_A> <CHILD_A _attribA="ABC"> <CHILD_B Type="1"> <CHILD_C> <CHILD_D Type="1" Date="2010-08-31"> <CHILD_E _attribB="M0"> <CHILD_F>-0.32295</CHILD_F>...