Enron email

Algorithmic Indexing

9 May 2001, 02:24 UTC

sql

From
Cooper Richey cooper.richey@enron.com
To
colin.tip@enron.com
Date
Tue, 8 May 2001 19:24:00 -0700 (PDT)
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'