|
SELECT A.EMPLID , W.BEGIN_DT , SUM(A.SCHEDULED_HRS) FROM %Table(RS_SCHED_TASK) A , %Table(RS_TASK_TYPE) B , %Table(CAL_DETP_TBL) W , %Table(INSTALLATION_PC) I WHERE A.SYSTEM_SOURCE = 'RS' AND B.TASK_TYPE = A.TASK_TYPE AND B.SYSTEM_SOURCE = A.SYSTEM_SOURCE AND B.RS_ASSIGNMENT_FLAG = 'Y' AND A.DATE_UNDER_RPT BETWEEN W.BEGIN_DT AND W.END_DT AND W.SETID = I.ANALYSIS_SETID AND W.CALENDAR_ID = I.CAL_TYPE_WEEK AND W.BEGIN_DT BETWEEN %DateAdd(%CurrentDateIn,-6) AND %DateAdd(%CurrentDateIn,365) GROUP BY A.EMPLID, W.BEGIN_DT
|