Add an index to date and loop round that field then, be quicker than using a view.

I'm sure there's no need for the view, I'd just loop on the identity coulmn(or another suitable indexed column) and delete where less than min(ident column ) + 2000 depending...