for Tall Jeff
Q&A for SharePoint enthusiasts
-- Badges awarded per month -- for Tall Jeff select datepart(year, Date) Year, datepart(month, Date) Month, count(*) Count from Badges group by datepart(year, Date), datepart(month, Date) order by datepart(year, Date), datepart(month, Date)