Extended analytic and window functions in SQL 2012

This post explains couple of scenarios where new analytic and aggregation windowing functions of sql 2012 can be effectively used to achieve functionality as compared to sql 2008.In one of my previous postshttp://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html I’d explained the application of APPLY operator in various…