Sper ca am inteles bine...

Pt. SQL 2005:

WITH kcte(rec_no, rec_date)
AS (SELECT rec_no, MAX(rec_date) FROM Records GROUP BY rec_no)
SELECT r.rec_no, k.rec_date, r.rec_type
    FROM Records r JOIN kcte k ON r.rec_no = k.rec_no
WHERE
CONVERT(datetime, k.rec_date, 101) < CONVERT(datetime, '7/26/2007', 101) AND
r.rec_type IS NULL AND
k.rec_date = r.rec_date

Pentru SQL 2000, in loc de "cte" foloseste o "variabila tabel".