>>It is supposed to be slow. I am also wondering, are you sure there are no dates involved in this Running Total?
>
>There is a transaction date, 'dtTrans_DT'.
>
Does running total mean sum all records for the date less than current record dtTrans_DT? This is what I assume the running total is.
>>I guess you need procedural solution here.
>
>Not sure what you mean by this
In the link I gave you couple of days/weeks ago there were 3 solutions considered. The procedural solution was claimed to be the fastest, if I recall correctly.
If it's not broken, fix it until it is.
My Blog