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