SET DEFINE OFF; Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'WEDNESDAY', 1, 1, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'THURSDAY', 2, 1, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'FRIDAY', 3, 1, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SATURDAY', 4, 1, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SUNDAY', 5, 1, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'MONDAY', 6, 1, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'TUESDAY', 7, 1, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'WEDNESDAY', 8, 2, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'THURSDAY', 9, 2, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'FRIDAY', 10, 2, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SATURDAY', 11, 2, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SUNDAY', 12, 2, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'MONDAY', 13, 2, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'TUESDAY', 14, 2, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'WEDNESDAY', 15, 3, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'THURSDAY', 16, 3, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'FRIDAY', 17, 3, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SATURDAY', 18, 3, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SUNDAY', 19, 3, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'MONDAY', 20, 3, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'TUESDAY', 21, 3, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'WEDNESDAY', 22, 4, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'THURSDAY', 23, 4, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'FRIDAY', 24, 4, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SATURDAY', 25, 4, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'SUNDAY', 26, 4, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'MONDAY', 27, 4, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'TUESDAY', 28, 4, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'WEDNESDAY', 29, 5, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'THURSDAY', 30, 5, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('01/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'JANUARY', 1, 'FRIDAY', 31, 5, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SATURDAY', 1, 5, 'P', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SUNDAY', 2, 5, 'F', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'MONDAY', 3, 5, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'TUESDAY', 4, 5, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'WEDNESDAY', 5, 6, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'THURSDAY', 6, 6, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'FRIDAY', 7, 6, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SATURDAY', 8, 6, 'P', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SUNDAY', 9, 6, 'F', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'MONDAY', 10, 6, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'TUESDAY', 11, 6, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'WEDNESDAY', 12, 7, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'THURSDAY', 13, 7, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'FRIDAY', 14, 7, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SATURDAY', 15, 7, 'P', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SUNDAY', 16, 7, 'F', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'MONDAY', 17, 7, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'TUESDAY', 18, 7, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'WEDNESDAY', 19, 8, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'THURSDAY', 20, 8, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'FRIDAY', 21, 8, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SATURDAY', 22, 8, 'P', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'SUNDAY', 23, 8, 'F', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'MONDAY', 24, 8, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'TUESDAY', 25, 8, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'WEDNESDAY', 26, 9, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'THURSDAY', 27, 9, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('02/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'FEBRUARY', 2, 'FRIDAY', 28, 9, 'L', 28, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SATURDAY', 1, 9, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SUNDAY', 2, 9, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'MONDAY', 3, 9, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'TUESDAY', 4, 10, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'WEDNESDAY', 5, 10, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'THURSDAY', 6, 10, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'FRIDAY', 7, 10, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SATURDAY', 8, 10, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SUNDAY', 9, 10, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'MONDAY', 10, 10, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'TUESDAY', 11, 11, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'WEDNESDAY', 12, 11, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'THURSDAY', 13, 11, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'FRIDAY', 14, 11, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SATURDAY', 15, 11, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SUNDAY', 16, 11, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'MONDAY', 17, 11, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'TUESDAY', 18, 12, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'WEDNESDAY', 19, 12, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'THURSDAY', 20, 12, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'FRIDAY', 21, 12, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SATURDAY', 22, 12, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SUNDAY', 23, 12, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'MONDAY', 24, 12, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'TUESDAY', 25, 13, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'WEDNESDAY', 26, 13, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'THURSDAY', 27, 13, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'FRIDAY', 28, 13, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SATURDAY', 29, 13, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'SUNDAY', 30, 13, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('03/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1, 2014, 'MARCH', 3, 'MONDAY', 31, 13, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'TUESDAY', 1, 14, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'WEDNESDAY', 2, 14, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'THURSDAY', 3, 14, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'FRIDAY', 4, 14, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SATURDAY', 5, 14, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SUNDAY', 6, 14, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'MONDAY', 7, 14, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'TUESDAY', 8, 15, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'WEDNESDAY', 9, 15, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'THURSDAY', 10, 15, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'FRIDAY', 11, 15, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SATURDAY', 12, 15, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SUNDAY', 13, 15, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'MONDAY', 14, 15, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'TUESDAY', 15, 16, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'WEDNESDAY', 16, 16, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'THURSDAY', 17, 16, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'FRIDAY', 18, 16, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SATURDAY', 19, 16, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SUNDAY', 20, 16, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'MONDAY', 21, 16, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'TUESDAY', 22, 17, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'WEDNESDAY', 23, 17, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'THURSDAY', 24, 17, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'FRIDAY', 25, 17, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SATURDAY', 26, 17, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'SUNDAY', 27, 17, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'MONDAY', 28, 17, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'TUESDAY', 29, 18, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('04/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'APRIL', 4, 'WEDNESDAY', 30, 18, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'THURSDAY', 1, 18, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'FRIDAY', 2, 18, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SATURDAY', 3, 18, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SUNDAY', 4, 18, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'MONDAY', 5, 18, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'TUESDAY', 6, 19, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'WEDNESDAY', 7, 19, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'THURSDAY', 8, 19, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'FRIDAY', 9, 19, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SATURDAY', 10, 19, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SUNDAY', 11, 19, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'MONDAY', 12, 19, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'TUESDAY', 13, 20, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'WEDNESDAY', 14, 20, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'THURSDAY', 15, 20, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'FRIDAY', 16, 20, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SATURDAY', 17, 20, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SUNDAY', 18, 20, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'MONDAY', 19, 20, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'TUESDAY', 20, 21, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'WEDNESDAY', 21, 21, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'THURSDAY', 22, 21, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'FRIDAY', 23, 21, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SATURDAY', 24, 21, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SUNDAY', 25, 21, 'F', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'MONDAY', 26, 21, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'TUESDAY', 27, 22, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'WEDNESDAY', 28, 22, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'THURSDAY', 29, 22, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'FRIDAY', 30, 22, 'L', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('05/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'MAY', 5, 'SATURDAY', 31, 22, 'P', 31, 21); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SUNDAY', 1, 22, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'MONDAY', 2, 22, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'TUESDAY', 3, 23, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'WEDNESDAY', 4, 23, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'THURSDAY', 5, 23, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'FRIDAY', 6, 23, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SATURDAY', 7, 23, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SUNDAY', 8, 23, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'MONDAY', 9, 23, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'TUESDAY', 10, 24, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'WEDNESDAY', 11, 24, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'THURSDAY', 12, 24, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'FRIDAY', 13, 24, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SATURDAY', 14, 24, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SUNDAY', 15, 24, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'MONDAY', 16, 24, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'TUESDAY', 17, 25, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'WEDNESDAY', 18, 25, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'THURSDAY', 19, 25, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'FRIDAY', 20, 25, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SATURDAY', 21, 25, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SUNDAY', 22, 25, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'MONDAY', 23, 25, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'TUESDAY', 24, 26, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 5, 'WEDNESDAY', 25, 26, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'THURSDAY', 26, 26, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'FRIDAY', 27, 26, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SATURDAY', 28, 26, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'SUNDAY', 29, 26, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('06/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1, 2014, 'JUNE', 6, 'MONDAY', 30, 26, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'TUESDAY', 1, 27, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'WEDNESDAY', 2, 27, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'THURSDAY', 3, 27, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'FRIDAY', 4, 27, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SATURDAY', 5, 27, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SUNDAY', 6, 27, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'MONDAY', 7, 27, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'TUESDAY', 8, 28, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'WEDNESDAY', 9, 28, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'THURSDAY', 10, 28, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'FRIDAY', 11, 28, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SATURDAY', 12, 28, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SUNDAY', 13, 28, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'MONDAY', 14, 28, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'TUESDAY', 15, 29, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'WEDNESDAY', 16, 29, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'THURSDAY', 17, 29, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'FRIDAY', 18, 29, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SATURDAY', 19, 29, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SUNDAY', 20, 29, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'MONDAY', 21, 29, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'TUESDAY', 22, 30, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'WEDNESDAY', 23, 30, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'THURSDAY', 24, 30, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'FRIDAY', 25, 30, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SATURDAY', 26, 30, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'SUNDAY', 27, 30, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'MONDAY', 28, 30, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'TUESDAY', 29, 31, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'WEDNESDAY', 30, 31, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('07/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'JULY', 7, 'THURSDAY', 31, 31, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'FRIDAY', 1, 31, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SATURDAY', 2, 31, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SUNDAY', 3, 31, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'MONDAY', 4, 31, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'TUESDAY', 5, 32, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'WEDNESDAY', 6, 32, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'THURSDAY', 7, 32, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'FRIDAY', 8, 32, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SATURDAY', 9, 32, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SUNDAY', 10, 32, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'MONDAY', 11, 32, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'TUESDAY', 12, 33, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'WEDNESDAY', 13, 33, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'THURSDAY', 14, 33, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'FRIDAY', 15, 33, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SATURDAY', 16, 33, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SUNDAY', 17, 33, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'MONDAY', 18, 33, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'TUESDAY', 19, 34, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'WEDNESDAY', 20, 34, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'THURSDAY', 21, 34, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'FRIDAY', 22, 34, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SATURDAY', 23, 34, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SUNDAY', 24, 34, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'MONDAY', 25, 34, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'TUESDAY', 26, 35, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'WEDNESDAY', 27, 35, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'THURSDAY', 28, 35, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'FRIDAY', 29, 35, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SATURDAY', 30, 35, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('08/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'AUGUST', 8, 'SUNDAY', 31, 35, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'MONDAY', 1, 35, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'TUESDAY', 2, 36, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'WEDNESDAY', 3, 36, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'THURSDAY', 4, 36, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'FRIDAY', 5, 36, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SATURDAY', 6, 36, 'P', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SUNDAY', 7, 36, 'F', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'MONDAY', 8, 36, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'TUESDAY', 9, 37, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'WEDNESDAY', 10, 37, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'THURSDAY', 11, 37, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'FRIDAY', 12, 37, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SATURDAY', 13, 37, 'P', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SUNDAY', 14, 37, 'F', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'MONDAY', 15, 37, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'TUESDAY', 16, 38, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'WEDNESDAY', 17, 38, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'THURSDAY', 18, 38, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'FRIDAY', 19, 38, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SATURDAY', 20, 38, 'P', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SUNDAY', 21, 38, 'F', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'MONDAY', 22, 38, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'TUESDAY', 23, 39, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'WEDNESDAY', 24, 39, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'THURSDAY', 25, 39, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'FRIDAY', 26, 39, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SATURDAY', 27, 39, 'P', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'SUNDAY', 28, 39, 'F', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'MONDAY', 29, 39, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('09/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 2, 2014, 'SEPTEMBER', 9, 'TUESDAY', 30, 40, 'L', 30, 22); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'WEDNESDAY', 1, 40, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'THURSDAY', 2, 40, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'FRIDAY', 3, 40, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SATURDAY', 4, 40, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SUNDAY', 5, 40, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'MONDAY', 6, 40, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'TUESDAY', 7, 41, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'WEDNESDAY', 8, 41, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'THURSDAY', 9, 41, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'FRIDAY', 10, 41, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SATURDAY', 11, 41, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SUNDAY', 12, 41, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'MONDAY', 13, 41, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'TUESDAY', 14, 42, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'WEDNESDAY', 15, 42, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'THURSDAY', 16, 42, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'FRIDAY', 17, 42, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SATURDAY', 18, 42, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SUNDAY', 19, 42, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'MONDAY', 20, 42, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'TUESDAY', 21, 43, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'WEDNESDAY', 22, 43, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'THURSDAY', 23, 43, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'FRIDAY', 24, 43, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SATURDAY', 25, 43, 'P', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'SUNDAY', 26, 43, 'F', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'MONDAY', 27, 43, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'TUESDAY', 28, 44, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'WEDNESDAY', 29, 44, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'THURSDAY', 30, 44, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('10/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'OCTOBER', 10, 'FRIDAY', 31, 44, 'L', 31, 23); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SATURDAY', 1, 44, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SUNDAY', 2, 44, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'MONDAY', 3, 44, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'TUESDAY', 4, 45, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'WEDNESDAY', 5, 45, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'THURSDAY', 6, 45, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'FRIDAY', 7, 45, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SATURDAY', 8, 45, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SUNDAY', 9, 45, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'MONDAY', 10, 45, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'TUESDAY', 11, 46, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'WEDNESDAY', 12, 46, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'THURSDAY', 13, 46, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'FRIDAY', 14, 46, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SATURDAY', 15, 46, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SUNDAY', 16, 46, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'MONDAY', 17, 46, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'TUESDAY', 18, 47, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'WEDNESDAY', 19, 47, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'THURSDAY', 20, 47, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'FRIDAY', 21, 47, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SATURDAY', 22, 47, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SUNDAY', 23, 47, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'MONDAY', 24, 47, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'TUESDAY', 25, 48, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'WEDNESDAY', 26, 48, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'THURSDAY', 27, 48, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'FRIDAY', 28, 48, 'L', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SATURDAY', 29, 48, 'P', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('11/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'NOVEMBER', 11, 'SUNDAY', 30, 48, 'F', 30, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'MONDAY', 1, 48, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/02/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'TUESDAY', 2, 49, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/03/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'WEDNESDAY', 3, 49, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'THURSDAY', 4, 49, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'FRIDAY', 5, 49, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/06/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SATURDAY', 6, 49, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/07/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SUNDAY', 7, 49, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/08/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'MONDAY', 8, 49, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/09/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'TUESDAY', 9, 50, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'WEDNESDAY', 10, 50, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/11/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'THURSDAY', 11, 50, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'FRIDAY', 12, 50, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/13/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SATURDAY', 13, 50, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SUNDAY', 14, 50, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'MONDAY', 15, 50, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'TUESDAY', 16, 51, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/17/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'WEDNESDAY', 17, 51, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/18/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'THURSDAY', 18, 51, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'FRIDAY', 19, 51, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SATURDAY', 20, 51, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/21/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SUNDAY', 21, 51, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/22/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'MONDAY', 22, 51, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/23/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'TUESDAY', 23, 52, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/24/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'WEDNESDAY', 24, 52, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'THURSDAY', 25, 52, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/26/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'FRIDAY', 26, 52, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/27/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SATURDAY', 27, 52, 'P', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/28/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'SUNDAY', 28, 52, 'F', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/29/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'MONDAY', 29, 52, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/30/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'TUESDAY', 30, 53, 'L', 31, 20); Insert into S_DIM_TEMPO (KEY_TEMP, DATA, TRIM, SEM, ANN, MESE, MM, GIORNO, GG, N_SET, TIP_GIO, GG_SOL_MES, GG_LAV_MES) Values ((SELECT MAX(KEY_TEMP)+1 FROM S_DIM_TEMPO), TO_DATE('12/31/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 2, 2014, 'DECEMBER', 12, 'WEDNESDAY', 31, 53, 'L', 31, 20); COMMIT;