Convert rows to column in SQL server

Question

0.00/5 (No votes)

See more:

I have below table

Name Email MobileNo
1 0 1

OUTPUT TABLE

FiledName IsValid
Name 1
Email 0
MobileNo 1

What I have tried:

I have used pivot logic but do not get required output.

Posted 18-Jun-18 19:48pm

suneel kumar gupta

Updated 19-Jun-18 2:02am

v2

Add a Solution

Comments

Mohibur Rashid 19-Jun-18 1:49am

Show us the query.

2 solutions

Solution 1

You have to unpivot[^] data ;)

SQL

DECLARE @tmp TABLE(Name INT, Email INT, MobileNo INT)

INSERT INTO @tmp(Name, Email, MobileNo)
VALUES(1, 0, 1)


SELECT FieldName, IsValid
FROM @tmp AS Pvt
UNPIVOT(IsValid FOR FieldName IN (Name, Email, MobileNo)) AS UnPvt

Posted 18-Jun-18 20:13pm

Maciej Los

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kirthiga S · Accepted Answer · 2018-06-19T02:03:00

Solution 2

create table T (Name int,Email int,MobileNo int)
insert into T values(1,0,1)

select * from T

select FieldName,u.Isvaild from T unpivot(Isvaild for FieldName in (Name ,Email ,MobileNo)) u

Posted 19-Jun-18 2:03am

kirthiga S

Comments

suneel kumar gupta 26-Jun-18 5:46am

Thanks a lot!!!!
I need the same solution

Convert rows to column in SQL server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Convert rows to column in SQL server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us