Jump to content

Pre-define Rows To Commit Too


royarellano
 Share

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...