[Slightly OT] Tricky SQL Query

2004-02-17 Thread A. Clausen
I am trying to construct what is proving to be a somewhat tricky SQL query. I have a database in which wireless activity data is dumped. The following is a boiled down version of what the table and the contents may look like: Date,Unit,InputOctets,OutputOctets,AccountingID 2004-01-31 23:59:05,0E

Re: [Slightly OT] Tricky SQL Query

2004-02-17 Thread Garth Webb
On Tue, 2004-02-17 at 11:00, A. Clausen wrote: I am trying to construct what is proving to be a somewhat tricky SQL query. I have a database in which wireless activity data is dumped. The following is a boiled down version of what the table and the contents may look like: Date,Unit

Tricky SQL query

2001-04-23 Thread Andrei Zmievski
Hi, I have a table that keeps track of when certain articles go up on the site. It has a field called featureStart, which is a unix timestamp. The features stay on the site until the next feature replaces them, so there is no featureEnd. If one feature started on Apr 23 and another one is