34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #T
(
id INT IDENTITY(1,1),
A VARCHAR(100)
)
INSERT INTO #T(A) VALUES('A;AB;A;ABC'),('A;AB;A;ABCA;AB;A;ABC'),('AA;AA;BB;BB')
SELECT id , STUFF((SELECT ';'+value FROM string_split(A,';')
GROUP BY value
FOR XML PATH('') ) ,1,1,'' )B FROM #T
DROP TABLE #T