What is the performance with CTE/Hierarcy when it comes to more than Millions of records getting inserted into table?

Thank you Lowell

This works 🙂

--------------------------------------------------------------------------------

Ok! this is what i did

Step 1: I cast Row_Description column as char(160)

step2: I add this expressions: = replace(First(Fields!Row_Description.Value), " ", "& n b s p ; ")...

Thank you Michael and Jeffrey!!! Michael's solution worked like a charm 🙂