Start with grabbing the external data from SQL Server.

Now it’s time to put that query inside a pivot table. While the post is about 2012, I installed my database on 2008 which is why I needed the 2008 data file in the link above.

Some database to connect to (whether it’s local or on a server). Management Studio (SSMS), test out the query, and then put the query inside anĮxcel pivot table in order to display the data. Instead, I usuallyĬreate a custom SQL query to one of our SQL Server databases using SQL Server Worksheet data like in most examples you’ll find online. And there aren’t many days that I don’tĬreate/use/manipulate pivot tables in some way. Subscribe About Terms Excel - Create a Pivot Table Using SQL