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
