InSQL is an add-on for Microsoft SQL. It makes use of many built in tables that become transparent for the end user.
The problem is I need to transfer Summary Data from it's temporary table(it will only store Summary Data for 2 weeks) to another table, and still keep it accessible to InSQL - so that other programs can still interface with the data properly.
Anyone here familiar with this database? How do I go about copying the data to another table?