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 DATE), CAST('TODAY' AS DATE)),
