Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
String agg
--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('1','27-10-2017'); insert into session_table values('1','28-10-2017'); insert into session_table values('2','27-10-2017'); insert into session_table values('2','28-10-2017'); insert into session_table values('3','27-10-2017'); insert into session_table values('4','29-10-2017'); insert into session_table values('4','27-10-2017'); insert into session_table values('3','29-10-2017'); insert into session_table values('5','28-10-2017'); insert into session_table values('5','10-10-2017'); insert into session_table values('8','23-10-2017'); insert into session_table values('8','29-10-2017'); 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
run
|
edit
|
history
|
help
0
Query through an error in Sql Server 2008 r2
test 2018.05.26
omnichannel_example
QUAN LY MAYBAY
1D Hotel
Exam_1
SALESPEOPLE
Pana la ex 7, inclusiv
string concatenation as aggregate operator in group by
SQL left join