WITH
--组长
a (zc1,zc2) AS (
SELECT CASE WHEN CHARINDEX(',', zc, 1) > 0
THEN CAST(LEFT(zc,CHARINDEX(',', zc,1) - 1) AS VARCHAR(20))
ELSE CAST(zc AS VARCHAR(20))
END AS zc1 ,--本次拆分字符
CASE WHEN CHARINDEX(',', zc, 1) > 0 THEN
STUFF(zc + ',' , 1, CHARINDEX(',', zc), '')
ELSE NULL
END AS zc2--待拆分字符串
FROM Matrixtable_1002 WHERE zc <> ''
UNION ALL
SELECT CAST(LEFT(zc2,NULLIF(CHARINDEX(',', zc2, 1),0) - 1) as VARCHAR(20) ) AS zc1 ,--本次拆分字符
STUFF(zc2, 1, CHARINDEX(',', zc2), '') AS zc2--待拆分字符串
FROM a
WHERE CHARINDEX(',', zc2, 1) > 0
)
SELECT DISTINCT zc1 AS zg1 FROM a
因篇幅问题不能全部显示,请点此查看更多更全内容
Copyright © 2019- ovod.cn 版权所有 湘ICP备2023023988号-4
违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务