Message-ID: <2937975.1075845330174.JavaMail.evans@thyme> Date: Mon, 7 May 2001 10:26:48 -0700 (PDT) From: matt.smith@enron.com To: david.woodstrom@enron.com Subject: RE: outage summary Cc: keith.holst@enron.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bcc: keith.holst@enron.com X-From: Smith, Matt X-To: Woodstrom, David X-cc: Holst, Keith X-bcc: X-Folder: \Smith, Matt\Smith, Matt\Sent Items X-Origin: SMITH-M X-FileName: Smith, Matt.pst 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 -----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