ls_filter = "v_car_truck_bus_trailer_materiaal_id = " +string(ll_materiaalid) +" AND ('" + string(idt_referentiedatum,"yyyy-mm-dd") + "' > 'dt_geldigvan' OR IsNull ('dt_geldigvan')) AND ( '" + string(idt_referentiedatum,"yyyy-mm-dd") + "' < 'dt_geldigtot' or IsNull ('dt_geldigtot'))"
select kentekennummer, p.personeelsnr, bp.dt_geldigvan, bp.dt_geldigtot,vctbt.materiaal_id from gloriant.v_car_truck_bus_trailer as vctbt left join gloriant.bestemmingsgoed_personeel as bp on bp.bestemmingsgoed_id = vctbt.bestemmingsgoed_id left join gloriant.personeel as p on bp.personeel_id = p.id where vctbt.dossier_id = 1 and materiaal_id = @index and( '2012-12-25' > dt_geldigvan or dt_geldigvan is null) and ( '2012-12-25' < dt_geldigtot or dt_geldigtot is null)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)