FORMAT versus CONVERT

• There is no need (or rare need) to use formating date2string in high volume/performance cases on database layer. Real word conversions will be done on business (DW...

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...