Group By - String column Agg, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

--select @@version as 'sql server version'

create table session_table
(
    
    sessionId varchar(100),
    log_timestamp varchar(100)
)
    
    
insert into session_table values('one','A');
insert into session_table values('one','A');
insert into session_table values('one','B');
insert into session_table values('one','B');
insert into session_table values('one','C');
insert into session_table values('one','C');
insert into session_table values('two','A');
insert into session_table values('two','A');
insert into session_table values('two','B');
insert into session_table values('two','B');
insert into session_table values('two','C');
insert into session_table values('two','C');

select a.sessionId, stuff( ( select ',' , b.log_timestamp from session_table b 
                     where a.sessionId = b.sessionId 
                     order by b.log_timestamp for xml path('a'), type).value('.','nvarchar(max)'),1,1,'') as time
from session_table a
group by a.sessionId

View schema
Execution time: 0,03 sec, rows selected: 2, rows affected: 12, absolute service time: 0,17 sec