--1.创建一个合并的函数 create function fmerg(@id int) returns varchar(8000) as begin declare @str varchar(8000) set @str='' select @str=@str+','+CorpName from 客户表 where ProjectID=@id set @str=right(@str,len(@str)-1) return(@str) End go--调用自定义函数得到结果 select distinct ProjectID,dbo.fmerg(ProjectID) from 客户表
select * into #aaa from 客户表 where ProjectID=@id update #aaa set @a=case when @b=ProjectID then @a else '' end+CorpName+',', 再查就可以了
create function fmerg(@id int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+CorpName from 客户表 where ProjectID=@id
set @str=right(@str,len(@str)-1)
return(@str)
End
go--调用自定义函数得到结果
select distinct ProjectID,dbo.fmerg(ProjectID) from 客户表
select * into #aaa from 客户表 where ProjectID=@id
update #aaa set @a=case when @b=ProjectID then @a else '' end+CorpName+',',
再查就可以了