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 ...
中关村在线

Oracle11g SQL新功能pivot/unpivot

领袖又说了：“温故而知新”。那就让我们先看看11g以前是怎么实现地。行列转换一直当作甄别老手和新手的试金石，面试的时候面试官不问这个都不好意思张嘴。Itpub的Oracle开发版更是每隔十天半个月就有人问这个，你说重要不重要。 表里放着张三李四王二 ...
Network World

PowerPivot with SQL Server 2008 R2

PowerPivot with SQL Server 2008 R2 One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”. Working with ...
dbta

Microsoft’s Trajectory for SQL Server Becomes Clear with PowerPivot

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, ...
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 ...