+1 Thanks for the review question. I've used XML PATH('') a few times for similar purpose.

+1 great question. Thanks!

+1 Thanks, this never occured to me.

+2 Thanks for the great question. I use PIVOT for some specific validation and testing scenarios, but it's not an every day thing. Thanks for the remind.

+2. Liike the previous post said, I aven't seen the some function outside of certification practice exams.

+7

+1

Good explanation. I don't get to work with this much.

Thanks 🙂

Thanks for the question.

Thanks for the great question.

+2 - thanks

Tricky Tricky 🙂

. Oops, sorry double posted.

+1 Thanks.

Andre Ranieri