John,

Thanks for the article, interesting read. We had a similar item here not long ago for a customized report, and I had the developer create a dynamic Pivot statement to achieve the results he needed using a string. This solution appears to produce similar results, but can be made more dynamic.

As you mentioned, I too detest the use of cursors and would change that to be a simple loop.

Whether or not this kind of script should be used in production is up to the developer (and their dba) but it provides great food for thought.