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