Operatore PIVOT

-- creo e popolo la tabella
set nocount on
create table TB ( pv char(2), tipo char(2), c1 char(1) )
insert into TB values ('AG','OV','A')
insert into TB values ('AG','OV','A')
insert into TB values ('AG','OV','B')
insert into TB values ('AG','OV','C')
insert into TB values ('AG','OV','C')
insert into TB values ('AG','OV','C')
insert into TB values ('AG','CP','A')
insert into TB values ('AG','CP','B')
insert into TB values ('AG','CP','B')
insert into TB values ('AG','CP','B')
insert into TB values ('AG','CP','C')
insert into TB values ('AG','CP','C')
insert into TB values ('AG','CP','C')
insert into TB values ('RM','OV','B')
insert into TB values ('RM','OV','B')
insert into TB values ('RM','OV','C')
insert into TB values ('RM','OV','C')
insert into TB values ('RM','CP','A')
insert into TB values ('RM','CP','A')
insert into TB values ('RM','CP','B')
insert into TB values ('RM','CP','C')
set nocount off

pv  tipo  A  B  C
--  ----  --  --  --
AG  OV  2  1  3
AG  CP  1  3  3
RM  OV  0  2  2
RM  CP  2  1  1

>Mi aiutate per favore ?

SELECT pv, tipo, A, B, C
FROM (
    SELECT pv, tipo, c1
    FROM dbo.TB
) AS SourceTable
PIVOT (
    COUNT(c1)
    FOR c1 IN ([A], [B], [C])
) AS PivotTable;

/* Output:

pv   tipo A           B           C
---- ---- ----------- ----------- -----------
AG   CP   1           3           3
RM   CP   2           1           1
AG   OV   2           1           3
RM   OV   0           2           2

(4 row(s) affected)

*/

>(sì, lo sò, sono una frana)

>Mi aiutate per favore ?

SELECT
    pv
  , tipo
  , [A]
  , [B]
  , [C]
FROM
  (SELECT pv, tipo, c1 FROM dbo.TB) AS SourceTable
  PIVOT
  (
    COUNT(c1)
    FOR c1 IN ([A],[B],[C])
  ) AS PivotTable