http://www2.sqlblog.com/blogs/adam_machanic/archive/tags/xml/dense_5F00_rank/default.aspxTags: xml, dense_rankenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspxMon, 03 Aug 2009 12:43:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15704Adam Machanic7http://www2.sqlblog.com/blogs/adam_machanic/comments/15704.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=15704When working with XML in SQL Server, you might want to uniquely identify one node against another. But due to the flexibility with which XML can be defined, this is not always directly possible. SQL Server's own XML structures are guilty of having this...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=15704" width="1" height="1">dense_rankxml