SELECT TOP 10 B.user_gid,LEFT(StuList,LEN(StuList)-1) as hobby FROM (

SELECT user_gid,

(

SELECT CAST(auth_type AS VARCHAR(50))+',' FROM credit.record_auth WITH(nolock)

WHERE user_gid=A.user_gid

FOR XML PATH('')

) AS StuList

FROM credit.record_auth AS A WITH(nolock)

GROUP BY user_gid

) B