Ars Technica

SQL Server PIVOT (with calendar weeks)

This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table ...
Ars Technica

SQL Server 2005: Pivot Help

I have a SQL Script that produces the following pivot query:<BR><BR> <pre class="ip-ubbcode-code-pre">SELECT ClientID, FirstName, LastName, SSN, 05/01/2009],[05/02 ...
Visual Studio Magazine

TFS 2010 Reporting Using Microsoft Excel – Part 2

In the second part of this two-part series, Mickey Gousset shows how TFS 2010 lets users create Excel reports, including pivot tables and charts, from a work item query. The report can then be ...
YouTube on MSN

Use Power Pivot to 10x your pivot tables

Upgrade your Pivot Tables in Excel with Power Pivot! This video covers how to use Power Pivot to analyze multiple Excel tables and files, overcoming the limitations of regular pivot tables. You'll lea ...