I have got two table Table A that contains huge records of logs and Table B as an archive table. I want to keep records for last 60 days starting from the current date in table A and all the other records will get automatically transferred to Table B and will get deleted from table a.
I there is a failure in the above while transferring then a roll back should happen.
I need an SQL query that will accomplish this when i execute it from a client application.I have attached a sample file for your reference.
With Kind Regards.