for xml path group by
摘要:
select a.prodid,stuff((select '/'+pc.name from Product_ProductChannel ppc(nolock) inner join ProductChannel pc(nolock) on ppc.productchannelid=pc.id where ppc.prodid=a.prodid for xml path('')),1,1,'')from Product_ProductChannel a(nolock) inner join ProductChannel b(nolock) on 阅读全文
posted @ 2014-02-12 15:59 习惯简单 阅读(823) 评论(0) 推荐(0) 编辑