I have a series of querys in my application that retieve data base on certain conditions.
I have a selection of records displayed in a grid that have been retrieved by a SQL query.
I want to copy/insert these records and all fields and values into a new table.
I need to copy the data into a table but only if a certain condition is met.
Copy all records that have been retrieved in the grid into my new table but only if they meet a True condition in a field called Flag.
Is it possible to do this in SQL or any other way.