Hi all,
Have you ever need a concatenation string function for group by clause?
Here is the solution.
http://www.projectdmx.com/tsql/rowconcatenate.aspx
And I like this process.
Ex)
set nocount on;
if OBJECT_ID(‘test’) is not null
drop table test
go
create table test
(
i int identity(1,1)
,c varchar(255)
)
go
insert into test (c)
select ‘a’
union all
select ‘b’
go 100
select i%2, replace(replace(max(b.list),”,”),”,”) as sum_c
from test a
cross apply (
select c + ‘,’ as c
from test
where i%2 = a.i%2
for xml path(”)
) b (list)
group by a.i%2
go
Simon's SQL 