I suspect this is a cast issue. Here is the error I am getting: __ 22 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 47 AND sdps.meter_id = chn.meter_id 48 AND (lp.utc_interval_time >= sdps.start_date AND 48 ! lp.utc_interval_time <= 48 ! COALESCE(sdps.end_date,'01jan2099:01:00:00'dt 48 ! /*CAST('2099-01-01 01:00:00'*/ as TIMESTAMP)) __ 22 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored.
... View more