I am not running it in transaction.

No one will access the DB when this procedure runs as it runs nightly.

I just want to modify the procedure so as to run in it batches...for ex processing 10000 records at a time