How to get sql output in the query mentioned

[Kristen]

Best Practice generating a delimited / concatenated list using FOR XML PATH

I have read that there is a length issue using FOR XML PATH but I have not been able to reproduce it (and maybe it was related to the Column Display Length Limit in SSMS ...) I typically see this posted as SELECT P.Col1, P.Col2, ... , STUFF( ( SELECT ',' + MyValue FROM MyChildTable AS C WHERE C.MyKey = P.MyKey ORDER BY MyValue FOR XML PATH('') ) , 1, 1, '') AS MyValueList FROM MyParentTable AS P however that will "escape" XML charracters ">", "<", "&". The solutio…