SQLServerCentral.com Articles tagged pivot

Dynamic PIVOT CLR

Thu, 06 Dec 2012 07:00:00 UT

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Script to create dynamic PIVOT queries in SQL Server

Fri, 09 Nov 2012 07:00:00 UT

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.

A Stock Price Correlation Matrix

Mon, 14 May 2012 06:00:00 UT

Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Fri, 30 Apr 2010 06:00:00 UT

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.

Pivoting, Unpivoting and Aggregating

Wed, 18 Nov 2009 07:00:00 UT

We asked Phil Factor to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting the data in a variety of ways.

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Fri, 30 Apr 2010 06:00:00 UT

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.

PIVOT working incorrectly?

Tue, 13 May 2008 06:00:00 UT

One developer's journey through PIVOTing incorrectly.