Sandeep Kumar

Sandeep Kumar

  • 1.1k
  • 684
  • 61.7k

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

Mar 24 2022 10:36 AM

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

 


Answers (2)