Home Forums SQL Server 7,2000 T-SQL What is the best way to iterate XML elements in SQL? RE: What is the best way to iterate XML elements in SQL?

  • Maybe it would be nice to add something like

    Id = DENSE_RANK()() OVER (ORDER BY s.value('@PrecedenceIndex','int') )