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?

Never mind, I found out how how to extend SummaryHistory storage time using InSQL Configure. I extended the time period to 3.5 months, we'll see how it works out.

PP