Base Table contains 100K rows.
Table name - Base
Columns
-AppliedDate
-RecievedDate
-ApprovedDate
-Name
-Rack
-MatType
-Status
-Location
-Quantity
-Consumption
-Used
-Remaining
I want to create a same archieve table and transfer all data from base table to archieve table and keep only 4 months data in base table.