This may be simple, but I am not too familiar with databases. What I have is a table, Table1, that is updated regularly. It has about 30 columns, and I want to take a subset of the data from Table1 (10 columns and only certain rows), and regularly copy the data into a different table, Table2, so that I can keep that subset of data in Table2 longer than I keep the data in Table1. I need to automate this functionality, also.
Hopefully I've explained this well enough. I have ASE 22.214.171.124.