I have to create an sp for data cleansing process which will be run every night using scheduler.

The tables have few bidirectional relationship which will not allow to delete data....

Thanks Rodak. So I believe my sp will work fine. 🙂