Choose a XML node in SQL Server based on max value of a child element
- by Jay
I am trying to select from SQL Server 2005 XML datatype some values based on the max data that is located in a child node.
I have multiple rows with XML similar to the following stored in a field in SQL Server:
<user>
<name>Joe</name>
<token>
<id>ABC123</id>
<endDate>2013-06-16…