Enron email

Algorithmic Indexing

7 May 2001, 15:33 UTC

outage summary

From
David Woodstrom david.woodstrom@enron.com
To
Matt Smith
Date
Mon, 7 May 2001 08:33:23 -0700 (PDT)
 

SELECT DISTINCT Calendar.DateValue As OutageDate,

 SUM(CASE PlantChar.WSCCRegion WHEN 'DSW' THEN
       CASE UnitChar.Fuel_designation WHEN 'Alt' THEN
         CASE PlantOutage.OutageReason WHEN 'forced' THEN
          PlantOutage.CapacityOut
         ELSE 0 END
      ELSE 0 END
    ELSE 0 END)/24 AS 'DSW|Alt|forced'

FROM LinkServer.Fundamentals.dbo.LkpCalendar_Definitions2 AS Calendar INNER JOIN LinkServer.Fundamentals.dbo.LkpOUT_PlantOutage AS PlantOutage
 ON Calendar.DateValue BETWEEN PlantOutage.BeginOutageDate AND PlantOutage.EndOutageDate
 INNER JOIN LinkServer.Fundamentals.dbo.LkpOUT_PlantCharacteristics AS PlantChar
 ON PlantOutage.PlantID = PlantChar.PlantID
 INNER JOIN LinkServer.Fundamentals.dbo.LkpOUT_UnitCharacteristics AS UnitChar
 ON PlantOutage.PlantUnitID = UnitChar.PlantUnitID

Where Calendar.DateValue Between @BeginDate AND @EndDate
 AND PlantOutage.Approved = 'Y'

Group By Calendar.DateValue 

ORDER BY Calendar.DateValue