合并列 将多列汇总成一列

SELECT
T.Stu_Name,
T.Age,
LEFT(T.Hobby,LEN(T.Hobby)-1) AS Hobby
,

 LEFT(T.[AGA],LEN(T.[AGA])-1) AS [AGA]
FROM  (SELECT
  A.Stu_Name,
  SUM(A.Age) AS Age,
          (SELECT Hobby+'/' FROM Stu_Hobby WHERE Stu_Name=A.Stu_Name FOR XML PATH('')) AS Hobby,
            (SELECT CAST(Age AS NVARCHAR(50))+'/' FROM Stu_Hobby WHERE Stu_Name=A.Stu_Name FOR XML PATH('')) AS AGA
       FROM Stu_Hobby A
       GROUP BY A.Stu_Name
) T

 

 

 

     SET @Cols = STUFF((SELECT  ',' + QUOTENAME(Project) FROM #TempC FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '');