Re: Inserting New Primary Keys

Jean, I see your point. For the incremental data, which is very small, I should make sure that the PARTITION BY in the OVER(PARTITION BY ...) is left out so that all the data will be in one partition when assigned a row number. The query below should avoid any problems. “SELECT ROW_NUMBER() OV

Re: Inserting New Primary Keys

Is there only one process adding rows? because this seems a little risky if you have multiple threads doing that… > On Oct 8, 2016, at 1:43 PM, Benjamin Kim wrote: > > Mich, > > After much searching, I found and am trying to use “SELECT ROW_NUMBER() > OVER() + b.id_max AS id, a.* FROM source

Re: Inserting New Primary Keys

Mich, After much searching, I found and am trying to use “SELECT ROW_NUMBER() OVER() + b.id_max AS id, a.* FROM source a CROSS JOIN (SELECT COALESCE(MAX(id),0) AS id_max FROM tmp_destination) b”. I think this should do it. Thanks, Ben > On Oct 8, 2016, at 9:48 AM, Mich Talebzadeh wrote: > >

Re: Inserting New Primary Keys

can you get the max value from the current table and start from MAX(ID) + 1 assuming it is a numeric value (it should be)? HTH HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Inserting New Primary Keys

I have a table with data already in it that has primary keys generated by the function monotonicallyIncreasingId. Now, I want to insert more data into it with primary keys that will auto-increment from where the existing data left off. How would I do this? There is no argument I can pass into th