Aging report GP Dynamics

Using Pivot, coalesce, datediff

Dynamic pivoting

Dynamically create and/or execute a pivot sql statement against a provided table.

Dynamic table unpivot

Generate and execute dynamically select statement for unpivot table

PIVOT Me

PivotByDate clr stored procedure

This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.

Sales Report on a View

Sales Report based on a single view

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://qa.sqlservercentral.com. I read through questions that have already...

Dynamic PIVOT CLR

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

Script to create dynamic PIVOT queries in SQL Server

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

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