SELECT B.resultNo,resultList as result FROM ( SELECT resultNo,(SELECT CONVERT(nvarchar, questionnaireNo)+CONVERT(nvarchar, highestQuestionNo) FROM ResultAnalyze WHERE resultNo=A.resultNo ORDER BY questionnaireNo FOR XML PATH(‘‘)) AS resultList FROM ResultAnalyze A GROUP BY resultNo ) B
原文：http://www.cnblogs.com/Alf7/p/3576949.html
