Let me Re - query the same,

The idea is to have 3 paritions for each month when we hit the limit then remove the last partition, Issue here is when we do that we dont want the Isprocessed Flag rows to be gone they should be still in the DB and available online.

Sliding window is what i am looking for But the Partition function can be done only on one column AFAIK.

Is there any Stratergy? which you guys are already using.

I can write a proc for purge, This table is a aggregation of different Orders from different vendors.

That gives a lot more control but its not fast as Sliding window Archiving process. How to do a Sliding window with conditional data? is there a way to do this.