I can't seem to get anything to work My table (tbl_Promotions) has 3 columns which I'd like to create the pivot from -Promo_Item (the item name) -Promo_Week (the calendar date of the first Monday) -ID ...

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.

We’ve previously covered a few basics for pivot tables, a powerful Excel tool which helps digital marketers organize and understand data. Today we’re going a half-step beyond the basics of setting up ...

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