pivot

External Article

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

The Annual SQL Saturday in Baton Rouge

By

I’ve been to quite a few of the SQL Saturday Baton Rouge events. There...

25 Years of Redgate

By

I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company...

Read the latest Blogs

Forums

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Notebook Jobs in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Notebook Jobs in Azure Data...

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers