C# Evolution

Implementar PIVOT em SQL-Server

Exemplo prático pra criar Query PIVOT com SQL-Server

"Pontuação Total de Equipes por Ano"

CREATE table NBA (
season nvarchar(4),
team nvarchar(100),
points int
);

insert into NBA select '2003', 'Lakers', 5225
insert into NBA select '2004', 'Lakers', 5341
insert into NBA select '2002', 'Bulls', 6144
insert into NBA select '2003', 'Bulls', 5315
insert into NBA select '2004', 'Bulls', 5212
insert into NBA select '2002', 'Celtics', 6442
insert into NBA select '2003', 'Celtics', 5004
insert into NBA select '2004', 'Celtics', 4102


select *
from 
(
  SELECT season, team, points FROM CFL 
) src
pivot
(
  sum(points)
  for season in ([2002], [2003], [2004])
) piv;

Resultado:






Comments