Quote Originally Posted by divroro12 View Post
This has to be automated & delete will take forever....millions of records in the table as well as indexes & constraints
The process you posted would take much more time than a delete.
If you have large table perhaps the best alternative is to use partitioning.