Convert Raw Value into column as different Comumn header in sql server

Question

Please help me as soon as posible

This is the main table ,I want convert into as output result

select gp,Safety_Id,activity,Ua from TblPpe

Gp	Safety_Id	Activity	Ua
2	15	Helmet	4
3	16	Guard	5

Output Result:

Helmet_GP	Helmet_Safety_Id	Helmet_Activity	Helmet_Ua	Guard_Gp	Guard_Safety_Id	Guard_Activity	Guard_Ua
2	15	Helmet	4	3	16	Guard	5

Sandeep Kumar · Answer

I need result as output result as shown in table,please look carefully

Gajendra Jangid · Answer

WITH CTE_TestData as ( select AnalysisID = 44, RefID=27, RefColumn = 'Reporting_Currency' , Value= 'EUR' union all select 44, 27, 'Reporting_Currency' , 'EUR' union all select 44, 27, 'Reporting_Currency' , 'USD' union all select 44, 27, 'Reporting_Group' , '0001' union all select 44, 27, 'Reporting_Group' , '0001' union all select 44, 27, 'Reporting_Group' , '0002' union all select 44, 27, 'Reporting_Language' , 'EN' union all select 44, 27, 'Reporting_Language' , 'EN' union all select 44, 27, 'Reporting_Language' , 'DE' union all select 65, 27, 'Company_Code' , null union all select 65, 27, 'MANDT' , null union all select 65, 27, 'Reporting_Currency' , null ) select AnalysisID, Reporting_Currency, Reporting_Group, Reporting_Language from ( select *, rowno = row_number() OVER (PARTITION BY refid, analysisid, RefColumn Order By refid, analysisid, refcolumn) from CTE_TestData t ) unpvt PIVOT ( min (value) FOR RefColumn in ([Reporting_Currency], [Reporting_Group], [Reporting_Language])) pvt

Convert Raw Value into column as different Comumn header in sql server

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)