相邻记录汇总问题

[sito_hongta]

MS SQL查询，想实现如下的汇总效果，求指点，求思路

[lzw_0736]

WITH a1 (pluname,qty) AS 
(
SELECT '香皂',1 UNION all
SELECT '香皂',2 UNION ALL
SELECT '洗手液',1 UNION all
SELECT '香皂',1 UNION all
SELECT '香皂',1 UNION ALL
SELECT '香皂',2
)
,a2 AS
(
SELECT *,ROW_NUMBER() OVER(ORDER BY @@SERVERNAME) re
FROM a1
)
,a3 AS
(
SELECT *,re-ROW_NUMBER() OVER(PARTITION BY pluname ORDER BY re) re2
FROM a2
)
SELECT pluname,SUM(qty) qty
FROM a3
GROUP BY pluname,re2
ORDER BY MIN(re)

[sito_hongta]

lzw_0736，谢谢！！实现了我想要的结果 。 不知道有没有不使用With实现的方法！