Message-ID: <17750937.1075841479524.JavaMail.evans@thyme>
Date: Tue, 8 May 2001 19:24:00 -0700 (PDT)
From: cooper.richey@enron.com
To: colin.tip@enron.com
Subject: sql
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Cooper Richey
X-To: Colin Poon Tip <Colin Poon Tip/CAL/ECT@ECT>
X-cc: 
X-bcc: 
X-Folder: \ExMerge - Richey, Cooper\'Sent Mail
X-Origin: RICHEY-C
X-FileName: cooper richey 6-26-02.PST

SELECT MAX(ABDAteTime), DATEADD(hour,-24,MAX(ABDAteTime)) FROM AB_PoolGeneration_REalTime WHERE DataType = 'A'

EXEC sp_AB_GetGenerationData 
	@GenCode = 'FNG1', 
	@Interval = 'hourly',  
	@StartDate = '1 MAY 2001',
	@EndDate = '15 MAY 2001'