Two ways to accomplish this and it depends if you have Enterprise Edition or not.  If not, use partitioned views.  Each day is in its own table and you rebuild the view after each load (or use synonyms for the 30 days of tables and switch the synonym daily).  If you have EE you could use a partitioned table.  While writing this I starting thinking the partitioned view would be easier.