AndyRoberts

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

Finding holes in number sequences using CTEs and Ranking functions

I have had a number of customers looking to manage number sequences for various scenarios. An...

Author: Andy Roberts Date: 07/13/2011