Najib Abi Fadel [EMAIL PROTECTED] writes:
Any ideas??
Could this be done with aggregates ??
I think you're going to have to write code that reads all the records, keeps
state representing the current period start and the last seen end date and
outputs data every time it sees a gap like you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am searching for a way to have the minimum date and maximum
date for dates seperated by one week whitout gaps between them.
This is not something you can accomplish (easily) with just SQL,
so you will need some sort of higher language. Here's
Hi
i have atable of dates let's
say:
1/1/2004
8/1/2004
15/1/2004
29/1/2004
5/2/2004
12/2/2004
I am searching for a way to have the minimum date
and maximum date for dates seperated byone week whitout gaps between
them.
which will give the
followingoutput:
1/1/2004, 15/1/2004
29/1/2004