SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW dbo.VW_MAAND
AS
SELECT     TOP 100 PERCENT dbo.Maand(FLTIME) AS MAAND, dbo.Maand(FLTIME) AS MND, dbo.A_MAAND_T(FLTIME, GETDATE()) AS AMT, dbo.Jaar(FLTIME) 
                      AS JAAR, MAX(FITS030_Qtot2) - MIN(FITS030_Qtot2) AS TOT_FITS030, MAX(FITS041_Qtot2) - MIN(FITS041_Qtot2) AS TOT_FITS041, MAX(FITS042_Qtot2) 
                      - MIN(FITS042_Qtot2) AS TOT_FITS042, MAX(Ruwwaterdebiet_Qtot2) - MIN(Ruwwaterdebiet_Qtot2) AS TOT_FITS_RUW, MAX(Reinwaterdebiet_Qtot2) 
                      - MIN(Reinwaterdebiet_Qtot2) AS TOT_FITS_REIN, MAX(FITS300_Qtot2) - MIN(FITS300_Qtot2) AS TOT_FITS300, SUM(ALM_TOT_PRI) AS TOT_ALM_PRI, 
                      SUM(ALM_TOT_SEC) AS TOT_ALM_SEC, MAX(P001_Hrs2) - MIN(P001_Hrs2) AS UREN_P001, MAX(P002_Hrs2) - MIN(P002_Hrs2) AS UREN_P002, 
                      MAX(P023_Hrs2) - MIN(P023_Hrs2) AS UREN_P023, MAX(P004_Hrs2) - MIN(P004_Hrs2) AS UREN_P004, MAX(P005_Hrs2) - MIN(P005_Hrs2) 
                      AS UREN_P005, MAX(P024_Hrs2) - MIN(P024_Hrs2) AS UREN_P024, MAX(P007_Hrs2) - MIN(P007_Hrs2) AS UREN_P007, MAX(P008_Hrs2) 
                      - MIN(P008_Hrs2) AS UREN_P008, MAX(P009_Hrs2) - MIN(P009_Hrs2) AS UREN_P009, MAX(P021_Hrs2) - MIN(P021_Hrs2) AS UREN_P021, 
                      MAX(P022_Hrs2) - MIN(P022_Hrs2) AS UREN_P022, MAX(P012_Hrs2) - MIN(P012_Hrs2) AS UREN_P012, MAX(P025_Hrs2) - MIN(P025_Hrs2) 
                      AS UREN_P025, MAX(P026_Hrs2) - MIN(P026_Hrs2) AS UREN_P026, MAX(P027_Hrs2) - MIN(P027_Hrs2) AS UREN_P027, MAX(P015_Hrs2) 
                      - MIN(P015_Hrs2) AS UREN_P015, MAX(P016_Hrs2) - MIN(P016_Hrs2) AS UREN_P016, MAX(P017_Hrs2) - MIN(P017_Hrs2) AS UREN_P017, 
                      MAX(P018_Hrs2) - MIN(P018_Hrs2) AS UREN_P018, MAX(P019_Hrs2) - MIN(P019_Hrs2) AS UREN_P019, MAX(P020_Hrs2) - MIN(P020_Hrs2) 
                      AS UREN_P020, MAX(P311_Hrs2) - MIN(P311_Hrs2) AS UREN_P311, MAX(P312_Hrs2) - MIN(P312_Hrs2) AS UREN_P312, MAX(P313_Hrs2) 
                      - MIN(P313_Hrs2) AS UREN_P313, MAX(V321_Hrs2) - MIN(V321_Hrs2) AS UREN_V321, MAX(V322_Hrs2) - MIN(V322_Hrs2) AS UREN_V322, 
                      MAX(P501_Hrs2) - MIN(P501_Hrs2) AS UREN_P501, MAX(P502_Hrs2) - MIN(P502_Hrs2) AS UREN_P502, MAX(P503_Hrs2) - MIN(P503_Hrs2) 
                      AS UREN_P503, MAX(P504_Hrs2) - MIN(P504_Hrs2) AS UREN_P504, MAX(P505_Hrs2) - MIN(P505_Hrs2) AS UREN_P505, MAX(P506_Hrs2) 
                      - MIN(P506_Hrs2) AS UREN_P506, MAX(P507_Hrs2) - MIN(P507_Hrs2) AS UREN_P507, MAX(NSA99101_Hrs2) - MIN(NSA99101_Hrs2) 
                      AS UREN_NSA99101, MAX(NSA99102_Hrs2) - MIN(NSA99102_Hrs2) AS UREN_NSA99102, MAX(StepUp_kWh2) - MIN(StepUp_kWh2) AS kWh2_StepUp, 
                      MAX(MCC2A_kWh2) - MIN(MCC2A_kWh2) AS kWh2_MCC2A, MAX(Winning_kWh2) - MIN(Winning_kWh2) AS kWh2_Winning, MAX(HV09_kWh2) 
                      - MIN(HV09_kWh2) AS kWh2_HV09, MAX(Zuivering_kWh2) - MIN(Zuivering_kWh2) AS kWh2_Zuivering, MAX(P311_kWh2) - MIN(P311_kWh2) 
                      AS kWh2_P311, MAX(P312_kWh2) - MIN(P312_kWh2) AS kWh2_P312, MAX(P313_kWh2) - MIN(P313_kWh2) AS kWh2_P313, MAX(V321_kWh2) 
                      - MIN(V321_kWh2) AS kWh2_V321, MAX(V322_kWh2) - MIN(V322_kWh2) AS kWh2_V322, MAX(P501_kWh2) - MIN(P501_kWh2) AS kWh2_P501, 
                      MAX(P502_kWh2) - MIN(P502_kWh2) AS kWh2_P502, MAX(P503_kWh2) - MIN(P503_kWh2) AS kWh2_P503, MAX(P504_kWh2) - MIN(P504_kWh2) 
                      AS kWh2_P504, MAX(P505_kWh2) - MIN(P505_kWh2) AS kWh2_P505, MAX(P506_kWh2) - MIN(P506_kWh2) AS kWh2_P506, MAX(P507_kWh2) 
                      - MIN(P507_kWh2) AS kWh2_P507, MAX(Essent_kWh2) - MIN(Essent_kWh2) AS kWh2_Essent, MAX(Distributie_kWh2) - MIN(Distributie_kWh2) 
                      AS kWh2_Distributie, MAX(Trafo1_kWh2) - MIN(Trafo1_kWh2) AS kWh2_Trafo1, MAX(Trafo2_kWh2) - MIN(Trafo2_kWh2) AS kWh2_Trafo2, 
                      MAX(Generator1_kWh2) - MIN(Generator1_kWh2) AS kWh2_Generator1, MAX(Generator2_kWh2) - MIN(Generator2_kWh2) AS kWh2_Generator2, 
                      MAX(Algemeenrek_kWh2) - MIN(Algemeenrek_kWh2) AS kWh2_Algemeenrek, MAX(Totaal_kWh2) - MIN(Totaal_kWh2) AS TOT_kWh2
FROM         dbo.RAP_DAG
WHERE     (dbo.MAANDPERIODE(FLTIME, GETDATE()) = 1)
GROUP BY dbo.Maand(FLTIME), dbo.Jaar(FLTIME), dbo.A_MAAND_T(FLTIME, GETDATE())
ORDER BY dbo.Jaar(FLTIME), dbo.Maand(FLTIME)

GO