|Subject||Re: [firebird-support] Re: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)|
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 DATE), CAST('TODAY' AS DATE)),