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
(
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
扫一扫
1566
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
