Code: Select all
select *
from mytable
where COALESCE(DVALIDFROM, :PeriodTo) <= :PeriodTo
When the parameters are duplicated I get a 'required parameter not set' error when I try to execute the query.
Kind regards,
Erik
Code: Select all
select *
from mytable
where COALESCE(DVALIDFROM, :PeriodTo) <= :PeriodTo