‎11-19-2019 09:40 PM
Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
DatePart(dd, htblticket.date) As Day,
Count(htblticket.ticketid) As TicketsCreated
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date),
DatePart(dd, htblticket.date)
Having Max(htblticket.date) > GetDate() - 7
Order By Year Desc,
Month Desc,
Day Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now