Hi
i have a table 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 by one week whitout gaps between
them.
which will give the
following output:
1/1/2004 , 15/1/2004
29/1/2004 , 12/2/2004 Any ideas??
Could this be done with aggregates ??
|
- Re: [HACKERS] Creating a selective aggregate ?? Najib Abi Fadel
- Re: [HACKERS] Creating a selective aggregate ?? Greg Stark
- Re: [HACKERS] Creating a selective aggregate ?? Greg Sabino Mullane