Barney Lawrence continues a series on XML processing in SQL Server:
This post looks at a problem that can come up in XML messages that have perhaps not been thought out as well as we’d like and where we can’t uniquely identify one instance of a repeating element. The example we’ve used so far avoids this problem so we’ll switch to a sample that illustrates this problem.
Read on for the crux of the problem, as well as solutions.