I'll write more about this when I get the chance. But in the meantime, if you want the slides and scripts from my presentations in Wagga and at AdSSUG last week, then get them from http://msmvps.com/files/folders/robfarley/entry180018.aspx . It was on Ranking Functions and Windowing, or on the uses of the OVER clause, etc.
Temp tables – a blessing or a curse?
August 11, 2026