A while ago, someone gave me a XML path syntax to include in a SQL command to return child entries. It looked something like this:

SELECT Client.Name,SUBSTRING(COALESCE((SELECT ', '+RTRIM(Invoice.ID)
 FROM ClientInvoice (NOLOCK)
 WHERE ClientInvoice.NoClient=Client.Numero FOR XML PATH (''),TYPE).value('.','varchar(max)'),''),3,1000) AS InvoiceID
 FROM Client
 INNER JOIN Invoice ON Client.NoInvoice=Invoice.Numero

So, basically, the goal was to obtain in the SQL result a column named InvoiceID with all the Invoice.ID values separated by a comma and a space. So, I could have "1234, 1500, 1600, 1800" in the SQL result InvoiceID field.

This used to work. Now, it returns the same values such as "1234, 1234, 1234, 1234". I wonder if this is a configuration that got changed on SQL Server, a new version, etc.