select xxx_Guid,STUFF((select ','+guigexinghao_name fromxxxx where t.xxx_Guid=xxx_Guid for xml path('')),1,'')
from xxxx t group by xxx_Guid
order by 加 top
select xxx_Guid,STUFF((select ','+guigexinghao_name fromxxxx where t.xxx_Guid=xxx_Guid for xml path('')),1,'')
from xxxx t group by xxx_Guid
order by 加 top
