SQL多行分录合并一行

最新推荐文章于 2024-03-23 12:02:12 发布

冉水

最新推荐文章于 2024-03-23 12:02:12 发布

阅读量234

点赞数

分类专栏：数据库文章标签：编程语言

本文链接：https://blog.csdn.net/weixin_43726316/article/details/100093453

版权

数据库专栏收录该内容

8 篇文章 0 订阅

订阅专栏

SQL多行分录合并一行

select t1.finterid ,min(t1.fentryid) fentryid,
		fname =(stuff(
		(select ' '+fname from
		(select  t.FinterID finterid,
		fname=(stuff(
		(select ' '+fname from t_SubMessage where FinterID=t1.FInterID for XML path('')),1,1,''))+','
		from SHWorkBillEntry(nolock) t 
		left join t_SubMessage t1 (nolock) on t.FOperID = t1.FInterID) t2	 
		where FinterID=t1.FInterID for XML path('')),1,1,''))
		from 
		(
		select  t.FinterID finterid,t.fentryid fentryid,
		fname=(stuff(
		(select ' '+fname from t_SubMessage  where FinterID=t1.FInterID for XML path('')),1,1,''))+','
		from SHWorkBillEntry(nolock) t 
		left join t_SubMessage t1 (nolock) on t.FOperID = t1.FInterID
		) t1
		group by finterid

k3的工序计划合并工序