一条ＳＱＬ，请帮忙
CREATE TABLE #A(A INT,B INT)
INSERT INTO #A SELECT 1,2
CREATE TABLE #A(A INT,B INT)
INSERT INTO #A SELECT 1,3
INSERT INTO #A SELECT 2,4
INSERT INTO #A SELECT 2,5
INSERT INTO #A SELECT 3,6
INSERT INTO #A SELECT 3,7
SELECT * FROM #A T1
如何用一条SQL出以下结果
A B
1 2，3
2 4，5
3 6，7
谢谢
[解决办法]
CREATE TABLE #A(A INT,B INT)
INSERT INTO #A SELECT 1,2
INSERT INTO #A SELECT 1,3
INSERT INTO #A SELECT 2,4
INSERT INTO #A SELECT 2,5
INSERT INTO #A SELECT 3,6
INSERT INTO #A SELECT 3,7
go
SELECT *
FROM(
SELECT DISTINCT
A
FROM #A
)A
OUTER APPLY(
SELECT
[values]=STUFF(REPLACE(REPLACE(
(
SELECT B FROM #A N
WHERE A= A.A
FOR XML AUTO
), ' <N B= " ', ', '), ' "/> ', ' '), 1, 1, ' ')
)N
/*
A values
----------- ---------
1 2,3
2 4,5
3 6,7
*/
Drop table #a
