Sandeep Kumar

Sandeep Kumar

  • 1.1k
  • 684
  • 61.7k

how to convert raw data in below form

Mar 25 2022 4:47 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 SId Activity Ua
2 15 Helmet 4
3 16 Guard 5

Output Result:

Helmet_GP Helmet_SId Helmet_Activity Helmet_Ua Guard_Gp Guard_SId Guard_Activity Guard_Ua
2 15 Helmet 4 3 16 Guard 5

 


Answers (5)