Build a SQL Stored Procedure
Budget: $250 – $750 USD
Write a Purge Routine that understands how to read through cascading Foreign Key Relationships, to logically purge (delete) the children of the main Table that you want to purge.
We would want to have a Purge Control table where we would specify the Parent Table and the Column that the Date Based Purge should be based on and the Number of days to keep.
We would want to have a Purge Control table where we would specify the Parent Table and the Column that the Date Based Purge should be based on and the Number of days to keep.