WITH    rows AS 
        ( 
        SELECT  no1aliquidcounter, 
        ROW_NUMBER() OVER (ORDER BY ID) AS rn, 
        ID
        FROM    datatable
        WHERE ringnum = 120 
        ) ,
        M as
        (

SELECT
(mp.no1aliquidcounter - mc.no1aliquidcounter) /1000 AS no1aliquidcountdiff,
mc.ID  

FROM    rows mc 
JOIN    rows mp 
ON      mc.rn = mp.rn - 1 

),
RUNNER(
ID,
no1aliquidcountdiff,
no1aliquidcountdiffttl)
 AS
(
SELECT 
a.ID,
a.no1aliquidcountdiff,
 (SELECT 
SUM(b.no1aliquidcountdiff)
FROM M AS b
WHERE b.ID <= a.ID)
FROM M AS a
)
SELECT * FROM RUNNER