Sql group and transform.sql

/*
sql transform this result

A, 1, q
A, 2,  r
A, 3,  x
B, 1,  q
B, 2,  q

to this 

A, [1,2,3], [q,r,x]
B, [1,2], [q]
*/

DECLARE @Temp TABLE ([Group] NVARCHAR(1), Number INT, Letter NVARCHAR(1))

INSERT INTO @Temp VALUES ('A', 1, 'q')
INSERT INTO @Temp VALUES ('A', 2, 'r')
INSERT INTO @Temp VALUES ('A', 3, 'x')
INSERT INTO @Temp VALUES ('B', 1, 'q')
INSERT INTO @Temp VALUES ('B', 2, 'q')
INSERT INTO @Temp VALUES ('C', 2, 'q')
INSERT INTO @Temp VALUES ('C', 2, 'x')
INSERT INTO @Temp VALUES ('C', 3, 'x')
INSERT INTO @Temp VALUES ('C', 4, 'y')
INSERT INTO @Temp VALUES ('C', 5, 'z')

/* SOLUTION 1 - Trailing Commas */
SELECT DISTINCT [Group], 
	('[' + (SELECT DISTINCT CONVERT(NVARCHAR(2), Number)  + ',' AS [text()]
		FROM @Temp T1
	WHERE
		T1.[Group] = T2.[Group]
	FOR XML PATH('')) + ']') [Numbers],
	('[' + (SELECT DISTINCT CONVERT(NVARCHAR(2), Letter)  + ', ' AS [text()]
		FROM @Temp T1
	WHERE
		T1.[Group] = T2.[Group]
	FOR XML PATH('')) + ']') [Letters]
FROM
	@Temp T2

/* SOLUTION 2 - No Trailing Commas */
DECLARE @MaxAllowed INT = 100
SELECT DISTINCT [Group], 
	'[' + 
	(SELECT STUFF((
		SELECT DISTINCT TOP (@MaxAllowed) 
			', ',  CONVERT(NVARCHAR(2), Number) AS 'data()'
		FROM  
			@Temp T1
		WHERE
			T1.[Group] = T2.[Group]
		FOR XML PATH('')), 1, 2, '')) + ']' [Numbers],
	'[' + 
	(SELECT STUFF((
		SELECT DISTINCT TOP (@MaxAllowed) 
			', ',  CONVERT(NVARCHAR(2), Letter) AS 'data()'
		FROM  
			@Temp T1
		WHERE
			T1.[Group] = T2.[Group]
		FOR XML PATH('')), 1, 2, '')) + ']' [Letters]
FROM
	@Temp T2