【SQL 编程你也行】SQL Server中实现数据换行

在sql server 里，可以这么合并数据：

 

with  t
as
(

select 1 as id,'产品1' p,'类型1' as v union all
select 2 as id,'产品2','类型1' as v union all
select 3 as id,'产品3','类型1' as v union all
select 4 as id,'产品1','类型2' as v union all
select 5 as id,'产品4','类型2' as v union all
select 6 as id,'产品5','类型3' as v union all
select 7 as id,'产品6','类型3' as v union all
select 8 as id,'产品7','类型3' as v union all
select 9 as id,'产品8','类型3' as v union all
select 10 as id,'产品9','类型4' as v 
)

select  v,
        stuff(cast((select ','+tt.p from t tt where t.v = tt.v for xml path('')) as varchar(100)),1,1,'') as p
from t
group by v
/*
v	p
类型1	产品1,产品2,产品3
类型2	产品1,产品4
类型3	产品5,产品6,产品7,产品8