事例：

SELECT BeginCity, EndCity, FanDian, [CangWei]=STUFF((SELECT '/'+[CangWei]
                                                     FROM Test1 t
                                                     WHERE t.BeginCity=Test1.BeginCity AND t.EndCity=Test1.EndCity AND t.FanDian=Test1.FanDian
                                                    FOR XML PATH('')), 1, 1, '')
FROM Test1
GROUP BY BeginCity, EndCity, FanDian;