SQL Query Help needed for PIVOTing a table

Question

Hello All I have an intermediate table result which looks like this

ID                  Header                     CONTENT                    
------------------------------------------------------------                    
GUID 1              Header1                    123456                     
GUID 1              Header2                    Phone                    
GUID 1              Header3                    Main Street                    
GUID 2              Header1                    654321                     
GUID 2              Header2                    Phone                    
GUID 3              Header3                    Some Street

I need to transform this result set into something like this

ID        Header1    Header2     Header3                                        
----------------------------------------                    
GUID 1    123456     Phone       Main Street                     
GUID 2    654321     Phone       Some Street

I guess i have to use PIVOTing for the same. But im stuck in the point where i cannot use the COUNT/SUM operator inorder to get the CONTENT column.Can anyone help me with the query for achieving the result ???

Thanks in advance

Answer 1

declare @t table(ID varchar(100),Header varchar(100),CONTENT varchar(100))            
insert into @t            
select 'GUID 1', 'Header1','123456' union all            
select 'GUID 1', 'Header2','Phone' union all            
select 'GUID 1', 'Header3','Main Street' union all            
select 'GUID 2', 'Header1','654321' union all            
select 'GUID 2', 'Header2','Phone' union all            
select 'GUID 3', 'Header3','Some Street'            
            
select * from            
(            
    select id,header,content from @t            
) as t            
pivot            
(            
    max(Content) for Header in ([Header1],[Header2],[Header3])            
) as p

SQL Query Help needed for PIVOTing a table

Follow this question

Related Questions