Search results

from fact_aspect_emp_schedule_detail detail where --(your other filters) -- maybe filter on nom_day_key = getdate() if you want to. May need to cast getdate() as a string if it can't or you don't want it implicit and detail.mod_dt = ( select max(detail_sub.mod_dt) from...