Thank you both. This is exactly what I needed.

I found that I did not need the CTE and could simply

SELECT EventID, <other event columns>

,Properties = STUFF((

...