b1nary0mega
8/31/2015 - 3:28 PM

Move all 334 persons times to CH3

Move all 334 persons times to CH3

/*GET A LIST OF ALL EMPLOYEES THAT NEED TO HAVE TIMES MOVED 334 -> CH3 */
SELECT DISTINCT EMPLOYEE_ID,
  LAST_NAME,
  FIRST_NAME,
  TITLE,
  POS_CODE
FROM EMPLOYEE_PROFILE
WHERE unit_id = 'CH3'
AND POS_CODE <> 2;

/*Delete all entered times for CH3 for 9/20 forward */
DELETE
  (SELECT *
  FROM EMPLOYEE_TIMES
  WHERE EMPLOYEE_ID IN
    ( SELECT DISTINCT EMPLOYEE_ID
    FROM EMPLOYEE_PROFILE
    WHERE UNIT_ID = 'CH3'
    AND POS_CODE <> 2
    )
  AND UNIT_ID   = 'CH3'
  AND END_DTTM >= TO_DATE('09-20-15 00:00:00','mm-dd-yy hh24:mi:ss')
  );

/*MOVE ALL 334 TIMES ENTERED FOR CH3 FOLKS TO CH3 for 9/20 forward */
UPDATE
  (SELECT *
  FROM EMPLOYEE_TIMES
  WHERE EMPLOYEE_ID IN
    ( SELECT DISTINCT EMPLOYEE_ID
    FROM EMPLOYEE_PROFILE
    WHERE UNIT_ID = 'CH3'
    AND POS_CODE <> 2
    )
  AND UNIT_ID   = '334'
  AND END_DTTM >= TO_DATE('09-20-15 00:00:00','mm-dd-yy hh24:mi:ss')
  )
SET UNIT_ID = 'CH3';