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

Last Chance for Free: Excel Pivot Tables, PowerQuery and PowerPivot (worth $50)Last Chance for Free: Excel Pivot Tables, PowerQuery and PowerPivot (worth $50)0 0

Claim this complimentary eBook worth $50 for free, before the offer ends today, Sep 16. Excel is still the most popular tool for organizing and analyzing data, and today's professionals are expected ...