不知道有关问题在那里了

SELECT s.SUBMITTIME ,s.FAULTLEVEL,COUNT(S.FLEVEL) AS [FLEVEL] FROM(SELECT Convert(nvarchar(100),a.SUBMITTIME,23) AS SUBMITTIME, b.FAULTLEVEL AS FAULTLEVEL,b.FAULTLEVEL AS FLEVEL from(select SUBMITTIME,FAULTLEVEL=convert(xml,'<root><v>'+replace(FAULTLEVEL,';','</v><v>')+'</v></root>') from [View_GetMMInfoForReport] as a outer apply(select FAULTLEVEL=c.v.value('.','nvarchar(100)')from a.FAULTLEVEL.nodes('/root/v') as c(v)) as b) as sGROUP BY s.SUBMITTIME,s.FAULTLEVEL