I would have thought that a SQL CLR function would provide the ideal solution here?

.NET is the right language to process complex types in a RBAR/loop manner; over...