Sorry for taking so long to come back to this. The function is nearly identical to one posted above, except that the xslt xml is also passed in as...

Any ideas as to the cause of the error below - from running the XML to XML function?

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ObjectDisposedException:...

Here's another approach; the main difference should be faster execution time at the cost of more code to write. So, up front, you've already decided what your partition criteria...

Good examples of using system tables.  I would use information_schema views except that not all of the information available via system tables exists in the views; and for that reason, I prefer to...