Solved

SQL PIVOT AND UNPIVOT Combination

Posted on 2011-03-18
2
695 Views
Last Modified: 2012-05-11
Please can you advise if there is some way of combining UNPIVOT and PIVOT.  I'm able to UNPIVOT a data set but then need to PIVOT the values for each unpivotted category across a series of months.

Thanks
0
Comment
Question by:Damozz
  • 2
2 Comments
 
LVL 9

Accepted Solution

by:
mayank_joshi earned 500 total points
ID: 35164501
0
 
LVL 9

Expert Comment

by:mayank_joshi
ID: 35164511
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question