Running below SQL query in powerserver:
select count(1)
into :ll_count
from message
WITH (NOLOCK)
where employeeid_to = :ll_employeeid
and warn = 'Yes' and isnull(DATEDIFF(day, cast(:now as date) , cast(messagedt as date)),0) < 1
and isnull(status, 'NULL') <> 'Completed'
error:
"ErrorCode": -1,
"ErrorMessage": "One or more errors occurred. (The parameter type cannot be deduced because a single expression contains two untyped parameters, '@P0' and '@P1'.)"
