Like any TSQL function that iterates through strings, this will run fine on small sets or a single field, but if you're going to use this in large set queries,...
Querying XML data in a set operation is relatively straight forward. Here's an excerpt from a query I have to retrieve content from a table with XML content, in...
For a domain specific language, in this case the domain being data management, T-Sql gets the job done. Having worked with both it (in MS and Sybase) as well...