>Building things the right way to begin with usually makes performance better.
>
>>After moving this into T-SQL it now executes twice as fast.
It was interesting to compare. The T-SQL code is not too simple either (uses a cursor and 3 temp tables)
If it's not broken, fix it until it is.
My Blog