SELECT AccountId,  
       TranDate,
       TranAmt,
       D.sumAmt AS older_method
       Sum(TranAmt) OVER(partition by Accountid 
                         ORDER BY TranDate 
                         RANGE UNBOUNDED PRECEDING) AS SumAmt        
FROM  #Transactions AS T1
CROSS APPLY (SELECT SUM(T2.TranAmt)
   FROM #Transactions AS T2
  WHERE T2.AccountId = T1.AccountId
    AND T2.TranDate <= T1.TranDate) AS D(SumAmt)
ORDER BY T1.AccountId, T1.TranDate;

Select ID,t.Name,Color 
  from TestSort
 Where t.color is not null
 order by  case when color = 'red' then 0 else 1 end,
           color;