Count of HF by Month

This query will give you a count of all hot fixes by Month. Keep in mind that a hot fix will have multiply version for example Windows 2000, Windows 2003, Windows XP, etc.



            datepart (YY,daterevised0) as ‘Year’,

            datepart (MM,daterevised0) as ‘Month’,

            count(datepart (MM,daterevised0)) as ‘Count’



Group by

            datepart (YY,daterevised0),

            datepart (MM,daterevised0)

Order by

            datepart (YY,daterevised0),

            datepart (MM,daterevised0)

Leave a Reply

Your email address will not be published. Required fields are marked *