T-SQL-连接变量#的行。

Code:

代码:

DECLARE @GroupByCnt INT = 3;

CREATE TABLE #Temp (ID VARCHAR(15))

INSERT INTO #Temp
SELECT '123'
UNION ALL  SELECT '123'
UNION ALL  SELECT '234'
UNION ALL  SELECT '345'
UNION ALL  SELECT '456'
UNION ALL  SELECT '456'
UNION ALL  SELECT '456'
UNION ALL  SELECT '567'
UNION ALL  SELECT '678'
UNION ALL  SELECT '789'
UNION ALL  SELECT '890'
UNION ALL  SELECT '901'
UNION ALL  SELECT '901'

SELECT DISTINCT STUFF((
            SELECT ',' + ID
            FROM #Temp T1
            WHERE T1.ID = T2.ID
            FOR XML PATH('')
            ), 1, 1, '') ID
FROM #Temp T2

DROP TABLE #Temp
DECLARE @GroupByCnt INT = 3;

CRE