Thanks +1.

I would recommend  doing a print @TheResult for a better view of the script instead of the CTE at the end  as some other poster has ...