Merge string groups using one SQL statement

This article uses an SQL statement to merge multiple rows in a column of an SQL table into a single value and a string group. If you need it, refer to "merge.

This article uses an SQL statement to merge multiple rows in a column of an SQL table into a single value and a string group. If you need it, refer to "merge.

The Code is as follows:
Declare @ t table (Id int, Value char (5 )) Insert into @ t '1', '09: 01 'union Select '1', '12: 05 'union Select '2', '08: 04 'union Select '2', '17: 09 'union Select '3', '123' Select * from @ t Select id, stuff (select ',' + rtrim (value) From @ t Where id = a. id for xml path ('') ), 1, 1, '') as [values] From (select distinct id from @ t)