use Leo go alter view dbo.vw_BudgetRunningBalance as select TrxId, TrxDate, TrxDate_ISO8601=convert(datetime, TrxDate, 126), TrxDescription, TrxAmount , sum(TrxAmount) over(order by TrxDate, TrxAmount desc rows unbounded preceding) RunningBal from dbo.BUDGET_DETAIL