34,590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([FPKID] int,[FEntryID] int,[F_PAEZ_MULBASE] int)
Insert #T
select 100001,100023,100567 union all
select 100002,100023,100435 union all
select 100005,100024,100201 union all
select 100006,100024,100278 union all
select 100007,100024,100280 union all
select 100008,100024,100283
Go
--测试数据结束
SELECT FEntryID ,
STUFF(( SELECT ',' + RTRIM(#T.[F_PAEZ_MULBASE])
FROM #T
WHERE FEntryID = a.FEntryID
FOR
XML PATH('')
), 1, 1, '') AS F_PAEZ_MULBASE
FROM #T a
GROUP BY a.FEntryID