create function fmerg(@id varchar)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+RoomNo from aa where id=@id
set @str=right(@str,len(@str)-1)
return(@str)
End
GO
select distinct id,dbo.fmerg(id) as pid from aa 哈哈哈，楼主给分吧
