Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag pivot Rss

Search for any content tagged pivot

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 15 of 15   
 

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.  Read more...
By Louis Nardozi 2013/10/30 | Source: SQLServerCentral.com | Category: pivot
Rating: (not yet rated) |  Discuss |   Briefcase | 917 reads

Sales Report on a View

Sales Report based on a single view  Read more...
By Sergiu Ungureanu 2013/09/17 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 1,178 reads

Convert Row to Column without using any other column for Pivot

Aim is to convert Row output having 3 rows of column Text to column output having 3 columns named as say Text1, Text2, Text3, without using any other column  Read more...
By ashish verma 2013/07/29 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 2,166 reads

Convert Row to Column without using any other column for Pivot

Aim is to convert Row output having 3 rows of column Text to column output having 3 columns named as say Text1, Text2, Text3, without using any other column  Read more...
By ashish verma 2013/07/29 | Source: SQLServerCentral.com | Category: pivot
Rating: (not yet rated) |  Discuss |   Briefcase | 687 reads

Using PIVOT

how can use pivot for reporting  Read more...
By Pankaj Upadhyay 2010/08/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,260 reads

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

Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char  Read more...
By Luigi Marinescu 2009/11/19 | Source: SQLServerCentral.com | Category: split
Rating: |  Discuss |   Briefcase | 1,301 reads

Dynamic Columns with PIVOT Operator

Script to convert to N Columns the rows in a table with PIVOT Operator  Read more...
By Felix Garcia Cruz 2009/06/05 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 1,836 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2010/06/02 | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 3,145 reads

Dynamic table not imposible

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.  Read more...
By William Mendoza 2009/02/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,750 reads

The Ultimate Index Width Stats Reporter

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.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,181 reads

Demonstration on how to pivot data using temp tables

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 :)  Read more...
By Chris Morton 2008/10/10 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 869 reads

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

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.  Read more...
By Jesse Roberge 2008/10/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,052 reads

The Ultimate Duplicate Index Finder

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.  Read more...
By Jesse Roberge 2008/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,943 reads

The Ultimate Index Usage Reporter

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.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,392 reads

The Ultimate Index Lister (Pivoted)

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.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,395 reads
   Items 1 to 15 of 15