group-concat – Read For Learn

GROUP_CONCAT comma separator – MySQL

February 7, 2022 by admin

I have a query where I am using GROUP_CONCAT and a custom separator as my results may contain commas: ‘—-‘ This all works well, however it is still comma separated, so my output is: How can I make it so the output is: I thought this was the idea of a custom separator! Failing that, … Read more

How to concatenate text from multiple rows into a single text string in SQL Server

December 27, 2021 by admin

If you are on SQL Server 2017 or Azure, see Mathieu Renda answer. I had a similar issue when I was trying to join two tables with one-to-many relationships. In SQL 2005 I found that XML PATH method can handle the concatenation of the rows very easily. If there is a table called STUDENTS Result I expected was: I … Read more