Extended analytic and window functions in SQL 2012 -2

This is a follow up post from http://visakhm.blogspot.com/2012/07/extended-analytic-and-window-functions.html to explain on some of new additions to OVER clause in SQL 2012 which gives us more flexibility in calculating running counts. Extending the earlier example, Lets consider scenario below Analyzing the sample…