SELECT STUFF(
(
SELECT
CONCAT(',',AccidentProjectID)--用逗号隔开
FROM dbo.TableName a where exists(select 1 from dbo.fnSplit('15,46,55',',')P where a.ProjectID in (P.col))
for xml path('')
),1,1,'') as AccidentUnitID
sqlserver 列转行逗号分隔
于 2022-10-08 09:30:21 首次发布