>>select top (N) N.Number from myTable T RIGHT JOIN Numbers N on T.IndexCol = N.Number >>WHERE T.IndexCol IS NULL >>ORDER BY N.Number