SqlServer2005 合并两个字符串的方法

 select distinct * from
(
select ijo_no,pmat_name,pmat_id=stuff((select '/'+pmat_id from (select * from @addTable ) a where a.ijo_no=b.ijo_no and a.pmat_name=b.pmat_name and a.qty=b.qty for xml path ('')),1,1,''),qty from @addTable b 
--where b.ijo_no='HLI110101143-1A'
) a