Thanks for attending my session on analyzing data with TSQL. 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.
The presentation can be found here: Analyzing with TSQL
The code was put into a Word document that you can get here: Code to support the analysis with TSQL Sessions
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
- CUBE, ROLLUP, GROUPING SETS: : https://technet.microsoft.com/en-us/library/bb522495(v=sql.105).aspx
