Select *
        Into #temp
        From 
        ( 
            select ‘A‘ id,‘aa‘ name
            union all
            select ‘A‘ id,‘bb‘ name
            union all
            select ‘A‘ id,‘cc‘ name
            union all
            select ‘B‘ id,‘aa‘ name
        )a
      
        Select * From #temp
        --查询   
        Select id,   
          name=stuff((select ‘,‘+name from #temp where id=t.id for xml path(‘‘)),1,1,‘‘)   
        From #temp t   
        Group by id   

        Drop Table #temp