查询的结果用逗号连接 有图

[loves0215cc]

SQL怎样写能变成下面这张图

[Landa_Jimmy]

引用 楼主 loves0215cc 的回复:

SQL怎样写能变成下面这张图

把数据用文本的形式贴出来

[loves0215cc]

引用 1 楼 u012173239 的回复:

[quote=引用 楼主 loves0215cc 的回复:] SQL怎样写能变成下面这张图

把数据用文本的形式贴出来 [/quote] jiangbingyu jiangshengnan menglingjun 办公自动化 jiangshengnan 初级会计实务 jiangshengnan 电脑应用高级班 jiangshengnan 海洋自动化精+串 jiangshengnan 会计就业直通车 jiangshengnan 会计学串讲 jiangshengnan 中级会计师 jiangshengnan 专升本VF+英语 jiangshengnan 是这样吗

[Landa_Jimmy]

create table #table(baomingzy varchar(50),call_user varchar(50))

insert into #table
select '','jiangbingyu' union all
select '','jiangshengnan' union all
select '','menglingjun' union all
select '办公自动化','jiangshengnan' union all
select '初级会计实务','jiangshengnan' union all
select '电脑应用高级班','jiangshengnan' union all
select '海洋自动化精+串','jiangshengnan' union all
select '会计就业直通班','jiangshengnan' union all
select '会计学串讲','jiangshengnan' union all
select '中级会计师','jiangshengnan' union all
select '专升本VF+英语','jiangshengnan' 

select distinct
(select stuff((
select ','+baomingzy from #table b where a.call_user=b.call_user
for xml path('')),1,1,''))baomingzy
,call_user
from #table a

baomingzy                                                                                                                                                                                                                                                        call_user
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------
                                                                                                                                                                                                                                                                 jiangbingyu
                                                                                                                                                                                                                                                                 menglingjun
,办公自动化,初级会计实务,电脑应用高级班,海洋自动化精+串,会计就业直通班,会计学串讲,中级会计师,专升本VF+英语                                                                                                                                                                                                      jiangshengnan

(3 行受影响)

[loves0215cc]

引用 3 楼 u012173239 的回复:

create table #table(baomingzy varchar(50),call_user varchar(50))

insert into #table
select '','jiangbingyu' union all
select '','jiangshengnan' union all
select '','menglingjun' union all
select '办公自动化','jiangshengnan' union all
select '初级会计实务','jiangshengnan' union all
select '电脑应用高级班','jiangshengnan' union all
select '海洋自动化精+串','jiangshengnan' union all
select '会计就业直通班','jiangshengnan' union all
select '会计学串讲','jiangshengnan' union all
select '中级会计师','jiangshengnan' union all
select '专升本VF+英语','jiangshengnan' 

select distinct
(select stuff((
select ','+baomingzy from #table b where a.call_user=b.call_user
for xml path('')),1,1,''))baomingzy
,call_user
from #table a

baomingzy                                                                                                                                                                                                                                                        call_user
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------
                                                                                                                                                                                                                                                                 jiangbingyu
                                                                                                                                                                                                                                                                 menglingjun
,办公自动化,初级会计实务,电脑应用高级班,海洋自动化精+串,会计就业直通班,会计学串讲,中级会计师,专升本VF+英语                                                                                                                                                                                                      jiangshengnan

(3 行受影响)

啥也不说了 NB 693929249 希望能加我QQ