pivot

Script to create dynamic PIVOT queries in SQL Server

  • Article

Pivoting is a common reporting requirement - data is stored in columns and you need to present it in rows. This was a nice feature that was added to SQL Server, but you don't always know all of the values you need to pivot on. This tip looks at how you can dynamically create the pivot command to handle these unknown values.

2012-11-09

5,308 reads

Blogs

Information Measurement with SQL Server, Part 4.9: The Bregman Divergence

By

By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...

Let’s Talk About The Cloud

By

I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...

Daily Coping 29 May 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Daily Coping 29 May 2020

By Steve Jones - SSC Editor

Today’s tip is today link your decisions and choices to your purpose in life....

Week Ending Thursday, can some one tweek my code?

By bark01

What I have missed from this code? I'm trying to show the DateTimeRaised field...

The Matchbox Database

By Phil Factor

Comments posted to this topic are about the item The Matchbox Database

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers