Using the OLE DB Provider for SQL Server/Analysis Services, the end-user can connect to a Data Source directly and build a Pivot Table or PivotChart using standard Excel functionality.

SQL Server PIVOT (with calendar weeks) ElPresidente408 Jun 25, 2010 Jump to latest Follow Reply ...

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

You poured data into a pivot table. Now what? Make them smarter. Here's how to use Summarizing Data and Calculated Fields in order to get a different perspective on your marketing data through the ...