Thank you already did that much appreciated
rds
>
>
>
> Stef
>
>
>
> *From:* firebird-support@yahoogroups.com [mailto:
> firebird-support@yahoogroups.com]
> *Sent:* 27 January 2019 11:50
> *To:* firebird-support@yahoogroups.com
> *Subject:* Re: [firebird-support] Consecutive values from different fields
&g
?
Regards
Stef
From: firebird-support@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: 27 January 2019 11:50
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Consecutive values from different fields
On 27/01/2019 08:03, 'Autoneer
On 27/01/2019 08:03, 'Autoneer' myauton...@gmail.com [firebird-support]
wrote:
> Thank you much appreciated, I would agree with Lester’s approach however
> this an inherited DB.
You need a ';' after the wd2 ... I think
Before we have CTE functions it was common to create temporary tables to
re
nd
end
suspend;
I have tried SQLFIDDLE and SQLTEST.NET but the only allow select statements
Any idea why this error would occur?
Regards
Stef
From: firebird-support@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: 26 January 2019 16:58
To: firebird-support@yahoogroups.com
Sub
ailto:firebird-supp...@yahoogroups..com]
Sent: 26 January 2019 16:58
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Consecutive values from different fields
>I have a question if you can help me PLEASE.
>
>Using a Firebird SQL query is it possible to count the consecuti
>I have a question if you can help me PLEASE.
>
>Using a Firebird SQL query is it possible to count the consecutive
number of matching values in different fields?
>I need to determine the LAST consecutive days a driver has been working.
>
>DPID WEEKDATE DRIVERNR DRIVER D1 D2
On 24/01/2019 07:50, 'Autoneer' myauton...@gmail.com [firebird-support]
wrote:
> 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 fro
On 24/01/2019 07:50, 'Autoneer' myauton...@gmail.com [firebird-support]
wrote:
> 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 fro
cte before and have no idea on how to
go about this.
Regards
Stef
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 24 January 2019 08:16
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Consecutive values from different fields
Den 2019-01-23 kl. 11:53, skrev 'Autoneer' myauton...@gmail.com
[firebird-support]:
>
> Good day all
>
> I have a question if you can help me PLEASE.
>
> Using a Firebird SQL query is it possible to count the consecutive
> number of matching values in different fields? I need to determine
Good day all
I have a question if you can help me PLEASE.
Using a Firebird SQL query is it possible to count the consecutive number of
matching values in different fields? I need to determine the LAST
consecutive days a driver has been working.
i.e. my table
DPID
WEEKDATE
DRIVERN
12 matches
Mail list logo