Hi Kibock,
Refer below code.
DECLARE @brudd_Los TABLE(BruddLosStatus CHAR(20),PersonYearOfBrudd INT)
INSERT INTO @brudd_Los VALUES('NySak',2017)
INSERT INTO @brudd_Los VALUES('NySak',2017)
INSERT INTO @brudd_Los VALUES('NySak',2017)
INSERT INTO @brudd_Los VALUES('NySak',2016)
INSERT INTO @brudd_Los VALUES('UnderBehandling',2016)
INSERT INTO @brudd_Los VALUES('Arkivert',2016)
INSERT INTO @brudd_Los VALUES('Til Overvaking',2016)
INSERT INTO @brudd_Los VALUES('NySak',2016)
INSERT INTO @brudd_Los VALUES('NySak',2016)
INSERT INTO @brudd_Los VALUES('UnderBehandling',2016)
INSERT INTO @brudd_Los VALUES('FerdigBehandlet',2016)
INSERT INTO @brudd_Los VALUES('NySak',2016)
INSERT INTO @brudd_Los VALUES('NySak',2016)
INSERT INTO @brudd_Los VALUES('NySak',2016)
INSERT INTO @brudd_Los VALUES('VenterSvar',2016)
INSERT INTO @brudd_Los VALUES('Til Overvaking',2016)
INSERT INTO @brudd_Los VALUES('Klar til raad',2016)
SELECT BruddLosStatus,ISNULL([2016],0) [2016],ISNULL([2017],0) [2017] FROM
(
SELECT BruddLosStatus,PersonYearOfBrudd,COUNT(PersonYearOfBrudd) 'Count'
FROM @brudd_Los
GROUP BY BruddLosStatus,PersonYearOfBrudd
)b
PIVOT
(
MAX([Count]) FOR [PersonYearOfBrudd] IN ([2016],[2017])
)pvt
Output
| BruddLosStatus |
2016 |
2017 |
| Arkivert |
1 |
0 |
| FerdigBehandlet |
1 |
0 |
| Klar til raad |
1 |
0 |
| NySak |
6 |
3 |
| Til Overvaking |
2 |
0 |
| UnderBehandling |
2 |
0 |
| VenterSvar |
1 |
0 |
