Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key data warehousing features and functions of SQL Server. In this screencast, Eric uses a typical DW query along with Microsoft Excel to create reports
Read More...
Read the complete post at http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/