SQLServerCentral.com Content tagged pivot

Using PIVOT

Mon, 02 Aug 2010 06:00:00 UT

how can use pivot for reporting

The Future of SQL Server Monitoring
Monitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.

Simple Crosstab Procedure with Power

Wed, 02 Jun 2010 06:00:00 UT

Create crosstab queries as easily as MS Access with a lot more power.

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

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.

Split string into table, separator can be more than 1 char

Thu, 19 Nov 2009 07:00:00 UT

Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char

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.

Dynamic Columns with PIVOT Operator

Fri, 05 Jun 2009 06:00:00 UT

Script to convert to N Columns the rows in a table with PIVOT Operator

Simple Crosstab Procedure with Power

Wed, 02 Jun 2010 06:00:00 UT

Create crosstab queries as easily as MS Access with a lot more power.

Dynamic table not imposible

Fri, 20 Feb 2009 07:00:00 UT

I needed to display my data in columns but could not use pivots or cross tables because it wasn't a fix amount of columns. so I created this script, I hope is useful.

The Ultimate Index Width Stats Reporter

Wed, 28 Jan 2009 07:00:00 UT

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.

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.

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Fri, 24 Oct 2008 06:00:00 UT

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.

The Ultimate Duplicate Index Finder

Fri, 17 Oct 2008 06:00:00 UT

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

The Ultimate Index Usage Reporter

Mon, 13 Oct 2008 06:00:00 UT

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.

Demonstration on how to pivot data using temp tables

Fri, 10 Oct 2008 14:10:52 UT

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

The Ultimate Index Lister (Pivoted)

Thu, 09 Oct 2008 06:00:00 UT

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.

PIVOT working incorrectly?

Tue, 13 May 2008 06:00:00 UT

One developer's journey through PIVOTing incorrectly.