如何串联多行？

对于SQL Server 2005+，请使用STUFF函数和FOR XML PATH：

WITH summary_cte AS (   SELECt Employee.Id, SUM(Pay) as Salary     FROM Employee     JOIN PayCheck ON PayCheck.EmployeeId = Employee.Id GROUP BY Employee.Id)SELECt sc.id,        sc.salary,       STUFF((SELECT ','+ yt.data     FROM your_table yt    WHERe yt.id = sc.id GROUP BY yt.data  FOR XML PATH(''), TYPE).value('.','VARCHAr(max)'), 1, 1, '')  FROM summary_cte sc

但是您缺少有关要转换为逗号分隔的字符串的数据的位置及其与员工记录的关系的详细信息…