对于sql Server 2012

SELECT  Qty,SUM(Qty) OVER (ORDER BY Qty) AS CumulativeTOTAL
FROM    tableName

> SQLFiddle Demo

对于sql Server 2008

SELECT a.Qty,(SELECT SUM(b.Qty)
               FROM   TableName b
               WHERE  b.Qty <= a.Qty)
FROM   TableName a
ORDER  BY a.Qty;

> SQLFiddle Demo