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

Articles with tag unpivot Rss

Search for any content tagged unpivot

   Items 1 to 4 of 4   
 

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.  Read more...
By Gregory Larsen 2015/06/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,774 reads

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.  Read more...
By Additional Articles 2015/06/16 | Source: Database Journal | Category: pivot
Rating:  Rate this |   Briefcase | 3,667 reads

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.  Read more...
By Dwain Camps 2014/09/26 (first published: 2012/08/02) | Source: SQLServerCentral.com | Category: cross apply values unpivot
Rating: |  Discuss |   Briefcase | 17,629 reads

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.  Read more...
By Dwain Camps 2014/09/26 (first published: 2012/08/02) | Source: SQLServerCentral.com | Category: cross apply values unpivot
Rating: |  Discuss |   Briefcase | 17,629 reads
   Items 1 to 4 of 4