Thanks, man. That's what I ended up doing. Still, I find that the first and
last functions need some serious reworking. Being that inconsistent just
doesn't make any sense.
"MGFoster" wrote:
Don't use FRIST() or LAST(). In your case use Min(date_column) for the
first date and Max(date_column) for the last date.
--
MGFoster:::mgf00 at earthlink decimal-point net
Oakland, CA (USA)
|