#cross tab query

[essentialsql]

Create a Pivot table in six steps to cross tabulate your data

Create a Pivot table in six steps to cross tabulate your data

In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart.

I’ll show you the steps using an example from the adventure works database. I get so many questions on how to create these!

Once you get the steps down, you’ll see they are not hard at all! I’ve seen where people get hung up in many ways, such as not knowing how to visualize the data, or…

View On WordPress

[essentialsql]

Create a Dynamic Pivot Table in SQL Server

Create a Dynamic Pivot Table in SQL Server

In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.  A dynamic pivot table is a great way to summarize data.  And given that Business Intelligence is a hot topic, knowing how to create one is key.

By reading this article you’ll learn to create a dynamic pivot table for yourself, but before you read the entire article, try the puzzle.  Any work you do, if it…

View On WordPress

[essentialsql]

Create a Cross Tab Query to Summarize Data in SQL Server

Create a Cross Tab Query to Summarize Data in SQL Server

In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.  Cross tabs are a great way to summarize data.  And given that Business Intelligence is a hot topic, knowing how to create one is key.

We’ll learn to create a cross tab query.  Before you read the entire article, try the puzzle.  Any work you do, if it you just get part of the answer, helps to reinforce the…

View On WordPress