Scripting

Hey all,

Per my usual situation I have been pounding my head on my desk trying to figure out what I'm doing wrong with my SQL reports. So I have decided to turn to the SQL Gurus of the IT Ninja community for help.

Here is the situation. I have two reports; one that pulls number of tickets and hours worked based on Owner, and the other pulls number of tickets and hours worked based on a custom field we made called Type. The issue is that the sum of ticket and hours worked are different per report. It appears that my Summary by Owner ticket is pulling the correct number of tickets. Any ideas would be most helpful. Thanks!
 
Summary by Owner report:

Select 

  ORG1.USER.FULL_NAME As TECHNICIAN,

  Count(DISTINCT ORG1.HD_TICKET.ID) As TICKETS,

  Sum(ROUND((Time_To_Sec(Time(ORG1.HD_WORK.STOP)) -

  Time_To_Sec(Time(ORG1.HD_WORK.START))) / 3600.0 +

  ORG1.HD_WORK.ADJUSTMENT_HOURS, 2)) As TOTAL_HOURS_WORKED

From

  ORG1.HD_TICKET Inner Join

  ORG1.HD_WORK On ORG1.HD_WORK.HD_TICKET_ID = ORG1.HD_TICKET.ID Inner Join

  ORG1.USER On ORG1.USER.ID = ORG1.HD_WORK.USER_ID

Where

  ORG1.HD_TICKET.HD_QUEUE_ID = 1 And

  isnull(ORG1.HD_WORK.VOIDED_BY) And

 ((date(HD_TICKET.TIME_CLOSED)  >= date_add( date_sub( curdate(), interval dayofyear(curdate())-1 day), interval ((quarter(curdate())-1)*3)-(3*1) month) and date(HD_TICKET.TIME_CLOSED)  <  date_add( date_sub( curdate(), interval dayofyear(curdate())-1 day), interval ((quarter(curdate())-1)*3) month)))

Group By

  ORG1.USER.FULL_NAME

Summary by Type:

Select 

  ORG1.HD_TICKET.CUSTOM_FIELD_VALUE5 As TYPE,

  Count(DISTINCT ORG1.HD_TICKET.ID) As TICKETS,

  Sum(ROUND((Time_To_Sec(Time(ORG1.HD_WORK.STOP)) -

  Time_To_Sec(Time(ORG1.HD_WORK.START))) / 3600.0 +

  ORG1.HD_WORK.ADJUSTMENT_HOURS, 2)) As TOTAL_HOURS_WORKED

From

  ORG1.HD_TICKET Inner Join

  ORG1.HD_WORK On ORG1.HD_WORK.HD_TICKET_ID = ORG1.HD_TICKET.ID

Where

  ORG1.HD_TICKET.HD_QUEUE_ID = 1 And

  isnull(ORG1.HD_WORK.VOIDED_BY) And

 ((date(HD_TICKET.TIME_CLOSED)  >= date_add( date_sub( curdate(), interval dayofyear(curdate())-1 day), interval ((quarter(curdate())-1)*3)-(3*1) month) and date(HD_TICKET.TIME_CLOSED)  <  date_add( date_sub( curdate(), interval dayofyear(curdate())-1 day), interval ((quarter(curdate())-1)*3) month)))

Group By

  ORG1.HD_TICKET.CUSTOM_FIELD_VALUE5