>What would be the easiest way to add records from a view (Temporary table) to another view (permanent table). Both have the same fields.
insert into mySecondView (column1, ...)
select Column1, ...
from myFirsrView
If it's not broken, fix it until it is.
My Blog