Pareto

Hvad med at bruge PIVOT:
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Ja, tabellen skal jo drejes, det har du ret i. Jeg fandt selv ud af det. I SQL sprog hedder det åbenbart "normalisering", og det var der en funktion til. Koden endte med at se sådan her ud:

TRANSFORM Avg([StopTime])
SELECT MIN([Start]) AS [MinStart], MAX([Start]) AS [MaxStart] 
FROM [dbo.qry_Events] 
WHERE ( 0 = 1 )
GROUP BY  DATEPART("yyyy",[Start]), DATEPART("y",[Start])
PIVOT [DescriptionEnglish] IN
("3 Errors in a row","3 fault in row on acctual fixture","Change silicone","Circuit breaker tripped","Doors open","Emergency stop","Error welding equipment","Maxtime","No catheter","No Communication with PC","No compressed air","No needle in magasin","Pin not free","Position fault index table","Sum Alarm Frequency converter","Wrong orentation membrane")

TRANSFORM Avg([Stoptid])
SELECT MIN([Start]) AS [MinStart], MAX([Start]) AS [MaxStart]
FROM [dbo.qry_Events]
WHERE ( 0 = 1 )
GROUP BY  DATEPART("yyyy",[Start]), DATEPART("y",[Start])
PIVOT [Kategori] IN ("A","B","C")