ISNULL( STUFF( (SELECT CAST(Fee AS VARCHAR(20)) +‘<br/>‘ FROM CollectionRecord c WITH(nolock) WHERE c.OrderCode=O.OrderCode FOR XML PATH(‘‘)),1,1,‘‘) ,‘‘) AS Fee
行转列
原文：http://www.cnblogs.com/q101301/p/4347200.html
