I need to add a line to this report with the ticket totals for the month....

The code below and I added a screen shot of the report.

select HD_CATEGORY.NAME, COUNT(HD_TICKET.ID)
from HD_TICKET
JOIN HD_CATEGORY on HD_TICKET.HD_CATEGORY_ID = HD_CATEGORY.ID
Where HD_TICKET.TIME_CLOSED BETWEEN '2014-02-01' AND '2014-02-28'
AND HD_TICKET.HD_QUEUE_ID = 1
GROUP BY HD_TICKET.HD_CATEGORY_ID

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity