Anonymous

SELECT COUNT(AlarmSummary.categoryID) AS numberof , AlarmSummary.categoryID , Category.name, Category.color, Category.level
		FROM
		AlarmSummary
		Inner Join Alarm ON AlarmSummary.alarmID = Alarm.alarmID
		Inner Join Organization ON Organization.organizationID = AlarmSummary.organizationID
		Inner Join Category ON AlarmSummary.categoryID = Category.categoryID
		where
		(MONTH(CONVERT(dayIndex, DATETIME)) = 5 )
		and
		(YEAR(CONVERT(dayIndex, DATETIME)) = 2005) 	

    and

AlarmSummary.CategoryId in
(
    select DISTINCT categoryId from AlarmSummary where
		(MONTH(CONVERT(dayIndex, DATETIME)) = 5 )
		and
		(YEAR(CONVERT(dayIndex, DATETIME)) = 2005)
		and
		(AlarmSummary.organizationid = 2 )
)

GROUP BY AlarmSummary.categoryID;