I have a date, and with this query I get the highest modificationDate for the given date.
SELECT max(ModificationDate) FROM dates WHERE ModificationDate<=@date
how could I get the LIST of HIGHEST modificationDate for a given LIST of DATES?
in another words, if @date is a list of dates! how could I get the same result?