[ad_1]

create table mpr (
name nvarchar(50),
value nvarchar(50)
);
insert mpr
select ‘Name’,’Ravi’ Union all
select ‘Gender’,’M’ Union all
select ‘Salary’,’38162′ Union all
select ‘Name’,’Sundar’ Union all
select ‘Gender’,’M’ Union all
select ‘Salary’,’34932′ Union all
select ‘Name’,’Jayesh’ Union all
select ‘Gender’,’M’ Union all
select ‘Salary’,’37224′ Union all
select ‘Name’,’Murali’ Union all
select ‘Gender’,’M’ Union all
select ‘Salary’,’43482′ Union all
select ‘Name’,’Priya’ Union all
select ‘Gender’,’F’ Union all
select ‘Salary’,’44831′ Union all
select ‘Name’,’Sandhya’ Union all
select ‘Gender’,’F’ Union all
select ‘Salary’,’26694′ Union all
select ‘Name’,’Karthik’ Union all
select ‘Gender’,’M’ Union all
select ‘Salary’,’36336′ Union all
select ‘Name’,’Premna’ Union all
select ‘Gender’,’F’ Union all
select ‘Salary’,’33432′;
select * from mpr
I want output as metioned below
[enter image description here][1]
[1]: https://i.stack.imgur.com/W3amD.png

select
case when name="Name" then value end as 'Name',

case when name="Gender" then value end as 'Gender',

case when name="Salary" then value end as 'Salary'

from mpr

Thank you.

[ad_2]