7 May 2001, 17:26 UTC
RE: outage summary
- From
- Matt Smith matt.smith@enron.com
- Cc
- Keith Holst
- Bcc
- Keith Holst
- Date
- Mon, 7 May 2001 10:26:48 -0700 (PDT)
David, I spot checked about 15-20 points and the data looks good. As I indicated before, can we run the query for 2001 as well...preferably using the quick method. Thanks. Mat
Quoted or forwarded from earlier messages
-----Original Message-----
From: Woodstrom, David
Sent: Monday, May 07, 2001 10:33 AM
To: Smith, Matt
Subject: outage summary
<< File: Outage Summary.xls >>
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