行列
来源：互联网 发布：淘宝买家秀木耳图片 编辑：程序博客网 时间：2024/04/30 04:13
create function fmerg(@id uniqueidentifier)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+'、'+cast(SuitedPeople as varchar)
from Rel_CommoditySuitedPeople
inner join Dim_SuitedPeople on Dim_SuitedPeople.SuitedPeopleId=Rel_CommoditySuitedPeople.SuitedPeopleId
where CommodityId=@id set @str=right(@str,len(@str))
return(@str)
End
go
