创建一个合并的函数:
create function fmerg(@type VARCHAR(10),@user VARCHAR(10))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+cast(USRAPP varchar(10)) from t where TYPE=@type and USER=@user
set @str=right(@str,len(@str)-1)
return(@str)
End
go--调用自定义函数得到结果
select TYPE,USER,dbo.fmerg(TYPE,USER) from t group by TYPE,USER
create function fmerg(@type VARCHAR(10),@user VARCHAR(10))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+cast(USRAPP varchar(10)) from t where TYPE=@type and USER=@user
set @str=right(@str,len(@str)-1)
return(@str)
End
go--调用自定义函数得到结果
select TYPE,USER,dbo.fmerg(TYPE,USER) from t group by TYPE,USER
2、写自定义函数,或使用临时表生成要的结果
pbsql(风云) :你干吗总妨碍我发财?