Subject Re: [firebird-support] Consecutive values from different fields
Author Lester Caine
On 24/01/2019 07:50, 'Autoneer' myautoneer@... [firebird-support]
> I have never worked with a recursive cte before and have no idea on how
> to go about this.

Personally I'd start by reordering the data to a single field ... It's
easy enough to DISPLAY a week at a time working from a table that has
single day records. The one can more easily scan the data for
'consecutive days' and also make calculations on 'hours' so giving the
right breaks between driving sessions.

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -