Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post them in comments and I will try to get you the answers.
Slides, Code, and Follow Up Posts
The presentation can be found here: A Window into Your Data
The code was put into a Word document that you can get here: TSQL Window Function Code
This session is also backed by an existing blog series I have written.
T-SQL Window Functions – Part 1- The OVER() Clause
T-SQL Window Functions – Part 2- Ranking Functions
T-SQL Window Functions – Part 3: Aggregate Functions
T-SQL Window Functions – Part 4- Analytic Functions
Microsoft Resources:
- OVER Clause: http://msdn.microsoft.com/en-us/library/ms189461(v=SQL.110).aspx
- Analytic Functions: http://msdn.microsoft.com/en-us/library/hh213234(v=sql.110).aspx
Come On Out to SQL Saturday 563 on September 24, 2016 for more great content
