How to convert horizontal row into vertical SQL Server

Question

Query:

Select 
    COUNT(aciklama)as Permitted,   
    (Select COUNT(aciklama) 
     from Uyari 
     where Aciklama like '%Blocked%') as Blocked 
From 
    Uyari 
where 
    Aciklama like '%Permitted%'

Output:

Permitted     Blocked
----------------------
    74         9194

I want result like this:

Permitted   ...      74
Blocked    ...     9194

Could any one help?

This is an "unpivot" action, which is answered in a number of other questions throughout stack overflow. — Griffin, May 13 '15 at 18:43
possible duplicate of [Unpivot with column name](http://stackoverflow.com/questions/19055902/unpivot-with-column-name) — Tab Alleman, May 13 '15 at 18:46
Tab Alleman I tried a lot but I din not make it, could you please help. — Mohamed Mohamed, May 13 '15 at 18:51

score 2 · Accepted Answer · answered May 13 '15 at 18:52

2

Here's one option using union all

select 'Permitted' action, COUNT(aciklama) as result
from Uyari 
where Aciklama like '%Permitted%'
union all
select 'Blocked' action, COUNT(aciklama)   
from Uyari 
where Aciklama like '%Blocked%'

answered May 13 '15 at 18:52

sgeddes

62,311
6
61
83

How to convert horizontal row into vertical SQL Server

1 Answers1