... ItemName,
DATEPART(dayofyear, ItemDate) as DayOfYear,
DATEPART(year, ItemYear) AS YearRun,
COUNT(ItemName) AS Counter
FROM
TableName
WHERE
ItemDate BETWEEN '01/01/2010' ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.