Using SQL Server 2012 Window Functions to Solve Common T-SQL Challenges

September 10, 2012 at 1:55 AMSteven Wang

Thanks to all who attended my session at the TechED New Zealand 2012. I hope that you have enjoyed the session. I have attached the presentation slides deck and Demo code in this blog.

Session Abstract:

SQL Server 2012 has introduced several new window functions and enhanced support for window aggregate functions by introducing window order and frame clauses, support for offset functions. In this session, the presenter will apply these new functions to solve some most frequently asked questions in MSDN T-SQL forum. If you have ever been faced with a challenge of how to calculate moving average, identify gap between records, combine consecutive and/or overlapped records and calculate running totals etc., then this session is for you.


Session Video:

Using SQL Server 2012 Window Functions 

Session Slides:

DBI309_Using_Window_Functions.pptx (1.79 mb)

Demo Code and DB:

TechEdNZ2012.bak (5.27 mb) (258.64 kb)



Posted in: SQL Server 2012 | T-SQL | Window Functions

Tags: , , ,

Comments (3) -

India best virtual server says:

Great stuff with some important details. Surely people will be able find the potentials as how it is written. Thanks for this nice post.


Comercializarea produselor naturiste pe baza de zeolit: Zeolit Protect, Zeolit Silicic, Zeolit Bionatura Plus, Zeolit Protect, Zeolit Protect Pulbere . Nu stiu ce treaba are cu ce e aici, dar stiu ca e bun.


United States narcotráfico unibank panama says:

I am often to blogging and i really appreciate your content. The article has really peaks my interest. I am going to bookmark your site and keep checking for new information.


Add comment