Creating stored procs that need to continusiouly append to a new table (this is to scrub d

I have 1 table with a huge amount of data that I recive from someone else in a flat file format. I want to be able to filter through that data and scrub it and find out the good data and bad data from it.

I'm scrubbing the data using different stored procs that i've created and through a web interface that the user can pick which records they wish to create.

If I were to create a new table for clean records, what is the syntax to keep Appending to that table through the data that i'm obtainig via the stored procs that i've created.

Any thoughts or suggestions are greatly appriciated in advance

Thanks again in advance
RBCheck outINSERT (INTO)

Or you might consider adding a STATUS column and flagging all records initially as BAD and then flagging with GOOD as appropriate as you progress through your scrubbing routines.

Terri