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

Question

Dear AllI would like to transfor the table below in SQL queryhttptinypiccomviewphppic262r7o8amps9Thanks in advance

dharmendr · Accepted Answer

Hi  KibockRefer below codeDECLARE bruddLos TABLEBruddLosStatus CHAR20PersonYearOfBrudd INTINSERT INTO bruddLos VALUES39NySak392017INSERT INTO bruddLos VALUES39NySak392017INSERT INTO bruddLos VALUES39NySak392017INSERT INTO bruddLos VALUES39NySak392016INSERT INTO bruddLos VALUES39UnderBehandling392016INSERT INTO bruddLos VALUES39Arkivert392016INSERT INTO bruddLos VALUES39Til Overvaking392016INSERT INTO bruddLos VALUES39NySak392016INSERT INTO bruddLos VALUES39NySak392016INSERT INTO bruddLos VALUES39UnderBehandling392016INSERT INTO bruddLos VALUES39FerdigBehandlet392016INSERT INTO bruddLos VALUES39NySak392016INSERT INTO bruddLos VALUES39NySak392016INSERT INTO bruddLos VALUES39NySak392016INSERT INTO bruddLos VALUES39VenterSvar392016INSERT INTO bruddLos VALUES39Til Overvaking392016INSERT INTO bruddLos VALUES

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

Company

Explore

Follow us

Contact Us