Calculate count of year on basis of name using PIVOT function in SQL Server

Search for Pivot Table in SQL

Thanks, but this is not quite related to my scenario

try to refer this link, it is almost your scenario

https://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

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