sql server - making a result vertical to horizontal

Asked Mar 02 '16 at 14:38

Active Mar 02 '16 at 14:42

Viewed 67 times

SELECT
    FirstName + '_count' AS firstName,
    COUNT(distinct FirstName) AS Count1
FROM
    test1(nolock)
GROUP BY
    FirstName

Result is coming up as:

firstName                                                Count1
-------------------------------------------------------- -----------
Bruce_count                                              1
Haley_count                                              1
Madeline_count                                           1
Marshall_count                                           1
Sophia_count                                             1

(5 row(s) affected)

I need it to be

firstName                                                Count1
-------------------------------------------------------- -----------
Bruce_count  Haley_count     Madeline_count    Marshall_count    Sophia_count                                
1  1  1  1  1 1 <br/>
(5 row(s) affected)

edited Mar 02 '16 at 14:42

Tom H

46,766
14
87
128

asked Mar 02 '16 at 14:38

How do you want the result?? Each `firstName` as a column? – Ullas Mar 02 '16 at 14:42
1

You do this either using `pivot` or conditional aggregation. – Gordon Linoff Mar 02 '16 at 14:44
[Pivot] (https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx) is what you are looking for – Anuj Tripathi Mar 02 '16 at 14:45
HI Ullaas yes , each first name to be a column – Mar 03 '16 at 12:46

sql server - making a result vertical to horizontal

0 Answers0