07.05.2015 20:23, sboyd...@gmail.com wrote:
The following query:
SELECT PB_LOAD_TYPE,
/* If already picked up use the pick up date.
If already delivered us the delivered date.
If appointment date present, use it.
Otherwise, use today's date */
Except that grouping by OPS_ZIP would not accomplish the same thing. Multiple
zip codes map to the same REGION_ID and the zip codes might not be contiguous.
Guess I'm going to have to rethink this.
What about
with tmp(PB_LOAD_TYPE, APPT_DATE, REGION_ID, PICKUP, DELIVERY) as
(SELECT
Hi,
I am having problems getting 2.5.4 to install on Linux Mint 17.1 using
the instructions at https://help.ubuntu.com/community/Firebird2.5
The installation starts ok, prompts for SYSDBA password, but then shows
the following:
# sudo apt-get install firebird2.5-super
Processing
SET;
That's slick. I'm going to have to read up on the WITH command.
Had to change the coalesce with all the dates to cast each date individually
or I got a conversion error. Not sure why.
COALESCE(CAST(OPS_ONBOARD_TIME AS DATE), CAST(OPS_DELIVERED_TIME AS DATE),
CAST(OPS_APPT_LOW AS
The following query:
SELECT PB_LOAD_TYPE,
/* If already picked up use the pick up date.
If already delivered us the delivered date.
If appointment date present, use it.
Otherwise, use today's date */
IIF(OPS_ONBOARD_TIME IS NOT NULL,