Thanks.

I was able to fix my issue as follows:

select

   A.TransactionID,

   A.TransactionDate,

   A.Amount,

   (select sum(amount) from [Transaction] B

    where B.TransactionDate < A.TransactionDate OR

          (B.TransactionDate = A.TransactionDate and...