Thanks, Tom. Granted, I have little to none of the nitty-gritty details but from what you have told us it sounds like it could have been done using T-SQL. I know one person on this thread salivating over the possibility of besting 1.2 seconds in terms of performance while using less CPU, memory and I/O than the SQLCLR object. Either way however, it appears you would have a code-maintenance challenge on your hands given the complexity.

I regularly see the choice of technology influenced by the technical strengths of existing team members, which is obviously a real concern to the success of any project. I am happy you have something maintainable that has reached an acceptable level of performance. Thanks again for posting those tips.