AndyRoberts

  • Article

More Fun with SQL Server “Denali” Window Functions

In my last post I described scenarios where the improvements to the SQL Server “Denali”...

Author: Andy Roberts Date: 08/22/2011

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...

Author: Andy Roberts Date: 08/22/2011

Re-summarizing data using UNPIVOT, ROW_NUMBER and CTEs

I had a question recently where a customer was presented a set of tables summarized by month and he...

Author: Andy Roberts Date: 07/13/2011