一.原数据：多行有序

SELECT CC.technameFROM PPEflow BB LEFT JOIN pubgyxxb CC ON BB.techno = CC.techno WHERE BB.Pdctno = ‘AT00101CA0‘ AND bb.flowLevel = 2 ORDER BY BB.globalOrder 

二.转换后数据：

SELECT ‘【‘ + CC.techname + ‘】-→‘ + ‘‘ FROM PPEflow BB LEFT JOIN pubgyxxb CC ON BB.techno = CC.techno WHERE BB.Pdctno = ‘AT00101CA0‘ AND bb.flowLevel = 2 ORDER BY BB.globalOrder FOR XML PATH(‘‘)