Código SQL:
Ver originalSELECT T1.prima, D1.VALUE, D2.VALUE, D3.VALUE
FROM (
SELECT prima, isnull([Field_A],0) AS [Field_A] ,isnull([Field_B],0) AS [Field_B], isnull([Field_C],0) AS [Field_C]
FROM (
SELECT prima, VALUE, name2
FROM details
) po
Pivot (
COUNT(VALUE)
FOR name2 IN ([Field_A], [Field_B], [Field_C])
) AS PVT
) T1
INNER JOIN details D1 ON T1.prima = D1.prima AND D1.name2 = 'Field_A'
INNER JOIN details D2 ON T1.prima = D2.prima AND D2.name2 = 'Field_B'
INNER JOIN details D3 ON T1.prima = D3.prima AND D3.name2 = 'Field_C'