I am new to SQL and have a special request for a report to determine if Help Desk hours need to change during certain times of the year. Thanks for any and all help.
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


Did you mean this resultset?

select count(*) as TotalTicketCount
  from HD_TICKET as t, HD_QUEUE as q
 where t.HD_QUEUE_ID = q.ID
   and q.NAME = 'Help Desk'
   and t.CREATED >= DATE_ADD(NOW(), INTERVAL -3 month)
Answered 06/02/2015 by: aragorn.2003
Red Belt

  • Aragorn - Thanks for you response. I will make the change to the interval to -24 months to gather enough historical data. This is what I have been working on as well:

    Select * from HD_TICKET
    where HD_QUEUE_ID = 1 and
    time(MODIFIED) >= ('15:00:00')
    order by created desc;

    I want to incorporate a count by month into my query. Currently, I can export the query into Excel and calculate these totals but sure would like to have it all done by the query if possible. Any further suggestions?
Please log in to comment