Re: [HACKERS] [GENERAL] creating a complex aggregate function

2004-07-09 Thread Najib Abi Fadel
29/01/2004:12/02/2004;    user1 25/12/2003:01/01/2004;15/01/2004:12/02/2004;    user2   I hope someone will help me in this issue. - Original Message - From: Najib Abi Fadel To: generalpost Cc: developPost Sent: Monday, July 05, 2004 12:23 PM Subject: [GENERAL] creat

[HACKERS] creating a complex aggregate function

2004-07-08 Thread Najib Abi Fadel
Hi i have an ordered 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 in a string. which will give the following output: 1/1/20

[HACKERS] Creating a selective aggregate ??

2004-07-01 Thread Najib Abi Fadel
  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