2 Jul
2014
2 Jul
'14
9:03 p.m.
Hi Dimitris, Good to hear that you got it to work. I would not know why putting the aggregation in the where clause would cause this behavior. When you said that it seems to have a better execution time, did you mean the original temporary table approach vs the working temporary table approach or the temporary table approach vs the row_number() approach? Cheers, Robin