Convert rows into columns using pivot query in SQL Server

tanweeru...

SOLVED CLOSED ACTIVE ANSWERED
User: tanweeruddinbeeharry
Posted: on Sep 26, 2021 10:57 PM
Forum: SQL Server
Answer: 1
Views: 1250

I need to split all 1 in one column and all 0 in another column.

Find below an snapshot of my table

58 /parentlogin 0

59 /teacherlogin 0

60 /studentregistration 1

31 /parentregistration 1

31 /teacherregistration 1

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Sep 27, 2021 03:56 AM
Report

Refer below query.

SQL

DECLARE @Test AS TABLE(ID INT,Name VARCHAR(50),Status TINYINT)
INSERT INTO @Test VALUES(58,'/parentlogin',1)
INSERT INTO @Test VALUES(59,'/teacherlogin',1)
INSERT INTO @Test VALUES(60,'/studentregistration',0)
INSERT INTO @Test VALUES(61,'/parentregistration',0)
INSERT INTO @Test VALUES(62,'/teacherregistration',0)

SELECT *
FROM(
		SELECT Id,Name,[Status]
		FROM @Test
	) p
PIVOT
(
	MAX([Name]) FOR [Status] IN ([0],[1])
) pvt

Output

Id	0	1
58	NULL	/parentlogin
59	NULL	/teacherlogin
60	/studentregistration	NULL
61	/parentregistration	NULL
62	/teacherregistration	NULL

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Convert rows into columns using pivot query in SQL Server

Company

Explore

Follow us

Contact Us