>Hi All,
>
>Brain freeze....having the following table how do I get the EDP and Alert Flg for the max(CaptureDate) ?
>
>

>CaptureDate			EDP	AlertFlg
>2009-01-05 15:28:21.860		15382	Zero
>2009-02-05 15:29:32.860		15382	Scheduled
>2009-03-05 15:29:31.860		15382	Low
>2009-01-05 15:28:21.860		32522	BO
>2009-02-05 15:29:32.860		32522	Zero
>2009-03-05 15:29:31.860		32522	Zero
>
>
>EDP	AlertFlg
>15382	Low
>32522	Zero
>

>
>Thank you,
>Daniel

For alternative solutions check this thread #1395684