SQL2008R2 STUFF查询出结果有误，请帮忙看下什么问题

[卸去人间妆红]

select containerid, xianghao= replace( (stuff((select ','+[xianghao] from vwcontainer t where containerid=vwcontainer.containerid for xml path('')), 1, 1, '')),' ','')
from vwcontainer
where parting='900210214-5-1'
group by containerid

以上是我查询的语句，查询出的结果为：

但实际结果应为（用语句查的）

select *  from vwcontainer where parting='900210214-5-1' order by containerid asc

就以MEDU7915645为例，实际应该是四个，但查询结果却是六个。百思不得其解，还望各位帮忙！谢谢！

[卸去人间妆红]

select containerid, [value] = stuff((select ',' + xianghao from vwcontainer t where containerid = vwcontainer.containerid and parting='900210214-5-2' for xml path('')) , 1 , 1 , '')  
from vwcontainer  
where containerid is not null
group by containerid  

此贴终结