More Fun with SQL Server “Denali” Window Functions

In my last post I described scenarios where the improvements to the SQL Server “Denali” windows functions could address a common scenario of getting year to date sales from a list of monthly amounts. In this post we will explore a couple of other advances in the Windows functions and how they might be applied…


Re-summarizing data using UNPIVOT, ROW_NUMBER and CTEs–Denali Style

  Last month I did a write up on a common scenario that I have seen with my customers where data needs to be re-summarized and the customer would like to avoid writing data into intermediate tables. For example, they may receive a flat file from an external source that has sales amount by month…