行转列

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