Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add Running Total To Query
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01329967
Message ID:
01329975
Views:
14
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform