Pre-define Rows To Commit Too

[royarellano]

Greetings All,I have three sets of data records (i.e., set1, set2, and set3) and I have a table. I would like to predefine where those sets of data are committed to on that table. I know that there may be other ways of doing this outside of what I'm asking here, but I decided not to go into the debate behind this decision and see if anyone could efficiently provide me an example of how this could be achieved.1. Statement must be able to delete all data in the predefined rows.2. Statement must then load the specific data set into the predefined rows.set1 assigned to rows 1-10set2 assigned to rows 11-20set3 assigned to rows 21-30Your feedback is greatly appreciated.v/rRoy

[justsomeguy]

If you have an ID for each of your rows it should be pretty easy to delete all rows with an ID in a certain range, a regular DELETE statement will do that. I guess the same goes with loading, if you're loading set 2 then you know the first record has an ID of 11, the second an ID of 12, etc.