PIVOT / UNPIVOT in SQL Server 2008

Posted by Nev_Rahd on Stack Overflow See other posts from Stack Overflow or by Nev_Rahd
Published on 2010-04-20T23:37:30Z Indexed on 2010/04/21 5:23 UTC
Read the original article Hit count: 477

Filed under:

pivot

|

unpivot

|

sql-server-2008

Hello

I got child / parent tables as below.

MasterTable:

MasterID, Description

ChildTable

ChildID, MasterID, Description.

Using PIVOT / UNPIVOT how can i get result as below in single row.

if (MasterID : 1 got x child records)

MasterID, ChildID1, Description1, ChildID2, Description2....... ChildIDx, Descriptionx

Thanks

© Stack Overflow or respective owner

Related posts about pivot

multiple pivot table consolidation to another pivot table

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to SQL Server views being drawn to 2 seperate worksheets as pivot tables in an excel 2007 file. the results on worksheet1 include example data: - company_name, tickets, month, year company1, 3, 1,2009 company2, 4, 1,2009 company3, 5, 1,2009 company3, 2, 2,2009 results from worksheet2… >>> More
Tool to automatically combine many large pivot table in many large Excel sheet ?

as seen on Super User - Search for 'Super User'
Hi all, We have several Excel files that contains large pivot data table with the same structure For example File A Pivot table (Field A, B, C) File B Pivot table (Field A, B, C) We want to combine them into 1 pivot table (A, B, C). Just want to know which ways we can do it ? Manual way :… >>> More
Nevron SharePoint Vision 2010 Vol.1 Now Available - advanced pivot Charts and Gauges for SharePoint

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Nevron Software - leader in enterprise and scientific data visualization technology, announces the availability of the new Nevron SharePoint Vision 2010 Vol.1 the Data Visualization suite for SharePoint! The major release is now available for download and includes Nevron Chart and Gauge web parts… >>> More
Lisp Style question label local functions or not?

as seen on Stack Overflow - Search for 'Stack Overflow'
I was wondering if there is a standard practice regarding the use of labels in Lisp. I've been messing around with a Lisp implementation of the algorithm described in the first answer here http://stackoverflow.com/questions/352203/generating-permutations-lazily My current version uses labels to… >>> More
New Skool Crosstabbing

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A while back I spoke about having to go back to BIP's original crosstabbing solution to achieve a certain layout. Hok Min has provided a 'man' page for the new crosstab/pivot builder for 10.1.3.4.1 users. This will make the documentation drop but for now, get it here! The old, hand method is still… >>> More

Related posts about unpivot

Dynamic Unpivot : SSIS Nugget

as seen on SQL Blog - Search for 'SQL Blog'
A question on the SSIS forum earlier today asked: I need to dynamically unpivot some set of columns in my source file. Every month there is one new column and its set of Values. I want to unpivot it without editing my SSIS packages that is deployed Let’s be clear about what we mean by Unpivot… >>> More
unpivot and PostgreSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a unpivot equivalent function in PostgreSQL? >>> More
PIVOT / UNPIVOT in SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I got child / parent tables as below. MasterTable: MasterID, Description ChildTable ChildID, MasterID, Description. Using PIVOT / UNPIVOT how can i get result as below in single row. if (MasterID : 1 got x child records) MasterID, ChildID1, Description1, ChildID2, Description2....… >>> More
PIVOT / UNPIVOT IN SQL 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I got child / parent tables as below. MasterTable: MasterID, Description ChildTable ChildID, MasterID, Description. Using PIVOT / UNPIVOT how can i get result as below in single row. if (MasterID : 1 got x child records) MasterID, ChildID1, Description1, ChildID2, Description2.......… >>> More
OTN???DB???????????????·Oracle ACE????????????????!

as seen on Oracle Blogs - Search for 'Oracle Blogs'
??????????? ???????????????????????????????????????? ????????????????????????”??????”??????????????????????????????????????????????????????????????????????????????????????(1)?????????????????(????????)?(2)?????????????????????(???????)????????????2?????????????????????????????????????????????????… >>> More