leixialx的博客

SELECT meterid , stuff((select ','+alarm from t_xhs_alarm_hie_copy where c.meterid=meterid for xml path('')),1,1,'') as alarm from t_xhs_alarm_hie_copy c group by c.meterid t_xhs_alarm_hi...