SELECT ., ., .,(SELECT TOP 1 2. FROM AS 2 WHERE 2. <. ORDER BY 2. DESC) AS _ FROM ORDER BY .
http://www.sql.ru/forum/1300387/zapolnenie-polya-znacheniyami-iz-predydushhih-strok-narastaushhim-itogom