Chaps, in future, I think I'll consider feeding XML into user-defined procs and functions (especially those written in managed code). I personally have only needed to do the most simple parsing of XML in T-SQL using the "SelectNodes" lookalike techniques, but I knows there's a lot more you can do. I'll probably be forced to return to this subject soon.
In the meantime I hard-coded a few CLR functions with different numbers of parameters to suit our needs. The general purpose method taht I planned can come later. - Greg
