Continue on Error

[TobiasKoller]

I need to instert 70.000 Records (Connections) with given IDs.
if the record with the id already exists it should continue and ignore the error .
I've created 70.000 Insert-Statements (because inserting by subselect is to complicated in my case).

Any idea how I can do that?

best regards
Tobias

[MarkMpn]

Does this work for you? https://github.com/MarkMpn/Sql4Cds/wiki/INSERT-queries#ignoring-duplicate-key-errors

[TobiasKoller]

hi Mark,

I've tried that before and that didnt work.
here is my statement and the error-result.