转换成   .....

是这样么   

--使用FOR XML的方式实现
select name,(
SELECT ',' + title FROM TestTitle subTitle WHERE name = TestTitle.name
FOR XML PATH('') ) as p
from TestTitle GROUP BY name

SELECT name,STUFF(
(
SELECT',' + title FROM TestTitle subTitle WHERE name = TestTitle.name FOR XML PATH('')
),1, 1, '') AS allTitle
FROM TestTitle GROUP BY name

--STUFF函数:删除指定长度的字符，并在指定的起点处插入另一组字符。
--参数1:操作数据源,参数2:指定起始位子,参数3:删除长度,参数4:插入新的数据源
SELECT STUFF('abcdef', 2, 2, 'A')

第二种方法 

--第一步，设置好分组的编号
--PARTITION BY将结果集分为多个分区。
--开窗函数分别应用于每个分区，并为每个分区重新启动计算。

SELECT
ROW_NUMBER() OVER(PARTITION BY name ORDER BY title) AS ID,
name,title FROM TestTitle ORDER BY name,title
-- 第二步，根据有编号的子查询，进行分组处理
SELECT name,
CASE WHEN COUNT(name) = 1 THEN MAX(title)
WHEN COUNT(name) = 2 THEN
MAX( CASE WHEN SubQuery.no = 1 THEN title + '，' ELSE '' END )
+ MAX( CASE WHEN SubQuery.no = 2 THEN title ELSE '' END )
WHEN COUNT(name) = 3 THEN
MAX( CASE WHEN SubQuery.no = 1 THEN title + '，' ELSE '' END )
+ MAX( CASE WHEN SubQuery.no = 2 THEN title + '，' ELSE '' END )
+ MAX( CASE WHEN SubQuery.no = 3 THEN title ELSE '' END )
END AS new_title
FROM
(
SELECT
ROW_NUMBER() OVER(PARTITION BY name ORDER BY title ) AS no,
name,title
FROM TestTitle
) subQuery
GROUP BY name