My reply was an efficient solution to your original problem. Now you've supplied more information I could suggest having a table only containing the records that you've processed. This will affect performance when selecting the data ie you'll now need to select all the raw data where there isn't a replacement "processed" record and then add all the processed records (this can be done in one select if you like).