Some database to connect to (whether it’s local or on a server).
Knowledge of SSMS and basic SQL queries.
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
