Agree - Row_Number() is more efficient there

I simply like to demonstrate how to go over limitations 🙂 with this next value over

Henn

some remarks

1. V11 (Azure) don't support OVER (ORDER BY) in Aggretates

2. the NEXT VALUE with OVER is interesting things to play

I'd like to persist current rank over order by some...