Greetings!<br clear="all"><br>I've got a pretty complex xquery that returns only the latest version of all items in a collection, but I know there has got to be a more efficient way to do it.<br><br>A simplified example of the XML that I'm dealing with (i.e. not invented here) is as follows:<br>
<br><items><br> <item><br> <id>1</id><br> <name>item # 1</name><br> <version>1</version><br> </item><br> <item><br>
<id>1</id><br>
<name>item # 1</name><br>
<version>2</version><br>
</item><br> <item><br>
<id>1</id><br>
<name>item # 1</name><br>
<version>3</version><br>
</item><br> <item><br>
<id>2</id><br>
<name>item # 2</name><br>
<version>1</version><br>
</item><br>
<item><br>
<id>2</id><br>
<name>item # 2</name><br>
<version>2</version><br>
</item><br>
<item><br>
<id>3</id><br>
<name>item # 3</name><br>
<version>1</version><br>
</item><br>
</items><br><br>What would be the most efficient way to do this?<br><br>Thanks in advance!<br><br>-- <br>A. Steven Anderson<br>Independent Consultant<br><a href="mailto:steve@asanderson.com" target="_blank">steve@asanderson.com</a><br>