Top 10 Ticket Types Year To Date
I found this code, but it only shows me the current month.How do I edit it, so that it shows the top 10 ticket types for Year To Date for the current year?Select Top 10 DatePart(yyyy, htblticket.date) As Year,DatePart(mm, htblticket.date) As Month,'....