通过查询SELECT DISTINCT SHIP_TO_NAME
from SHIPMENT_HEADER SH
where SH.ALTERNATE_EMAIL_ADDRESS = '24425'能得出如下结果:吉林省为实电工有限公司
朝阳区欧亚卖场四禾照明灯饰商行想实现的效果是:吉林省为实电工有限公司/朝阳区欧亚卖场四禾照明灯饰商行请教大家,有什么办法可以写么?
from SHIPMENT_HEADER SH
where SH.ALTERNATE_EMAIL_ADDRESS = '24425'能得出如下结果:吉林省为实电工有限公司
朝阳区欧亚卖场四禾照明灯饰商行想实现的效果是:吉林省为实电工有限公司/朝阳区欧亚卖场四禾照明灯饰商行请教大家,有什么办法可以写么?
DECLARE @s VARCHAR(8000)
SELECT @s=ISNULL(@s+'/','')+SHIP_TO_NAME
FROM (
SELECT DISTINCT SHIP_TO_NAME
from SHIPMENT_HEADER SH
where SH.ALTERNATE_EMAIL_ADDRESS = '24425'
) t
SELECT @s
from SHIPMENT_HEADER SH
where SH.ALTERNATE_EMAIL_ADDRESS = '24425'
FOR XML PATH('')),1,1,'') AS col