Generate datetime values from integers

This post is an extension to my earlier post regarding datetime formatting tips given below http://visakhm.blogspot.com/2010/01/some-quick-tips-for-date-formating.html The impetus behind creating this blog is the increasing requests I’ve had recently from my own colleagues as well as from many others through forums asking me…

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…

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…