Thank you @Sukhdevsinh for this writeup! 😎 Now my question is; Why would you like to concatenate multiple values into a single value? I consider that as an antipattern...

Thanks for the critical feedback! I appreciate your point, but the intent of my script wasn't to compare performance between the two methods. It was focused on providing a solution...

In case if you have missed, I did mention "You can also use STRING_AGG (SQL Server 2017+)  to achieve same results."

Thank you for your detailed feedback. I appreciate your thoughts on the sample used and the suggestion to use a more complex problem that justifies looping. I’ll consider updating the...