Hello,
I just asked a question on this thread :
Problem with AGGR and MAX Value on a DateRange
Someone give me a good answer who worked well but when i use it on the whole data i got (around 200k row) it took more than 5mn to work. It's too long, i tried some tricks but none worked...
If someone can help me on this, i will be gratefull.
PS : To try the whole data, change the vFrom value to 31/03/2016 23:59:59.
Pps : I can't modify the database, so i have to work with it.
PPps : Maybe the solution is to do the whole calcul in script ? The script will be regenerated at night, so it's not a problem if he take some times to be ready.