SQLServerCentral.com Articles tagged Crosstab

Reporting Services: Adding extra columns / rows to a matrix

Fri, 24 Jun 2011 06:00:00 UT

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Fri, 06 Aug 2010 06:00:00 UT

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.

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.

Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

Tips for Simplifying Crosstab Query Statements

Mon, 22 Feb 2010 07:00:00 UT

Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.

All About the Crosstab Query

Wed, 13 Jan 2010 07:00:00 UT

Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Fri, 06 Aug 2010 06:00:00 UT

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.

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.

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Fri, 06 Aug 2010 06:00:00 UT

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.

Reporting Services: Adding extra columns / rows to a matrix

Fri, 24 Jun 2011 06:00:00 UT

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.