dreptak

Gdańsk, Polska

2019
Dec
17
asked Entity Framework with SQL Server IGNORE_DUP_KEY
Nov
14
awarded Notable Question
Nov
8
accepted Read uncommited does not work in UPDATE WHERE NOT EXISTS
Nov
7
comment Read uncommited does not work in UPDATE WHERE NOT EXISTS
I think you're right in the first part... About second part: I've got a lot of records to map to newer ID, so this way won't work
Nov
7
revised Read uncommited does not work in UPDATE WHERE NOT EXISTS
Image with explanation
Nov
7
comment Read uncommited does not work in UPDATE WHERE NOT EXISTS
how I think this should look
Nov
7
awarded Custodian
Nov
7
revised Read uncommited does not work in UPDATE WHERE NOT EXISTS
Added clarification at the end of post
Nov
7
reviewed Approve suggested edit on Read uncommited does not work in UPDATE WHERE NOT EXISTS
Nov
7
comment Read uncommited does not work in UPDATE WHERE NOT EXISTS
The 3rd update you described should be excluded by WHERE NOT EXISTS clause - it should check if tuple (3,1) exists in table, and proceed with update only if it does not
Nov
7
asked Read uncommited does not work in UPDATE WHERE NOT EXISTS
Oct
22
awarded Supporter
2018
Nov
3
awarded Scholar
Nov
3
accepted How to think about queries in NoSQL
Nov
1
awarded Student
Nov
1
asked How to think about queries in NoSQL
Jul
19
awarded Popular Question
Jun
22
awarded Scholar
Jun
22
accepted Number of full table scans
Jun
22
comment Number of full table scans
After checking it seems you're right, thank you. Just add AND IUS.object_id = I.object_id in last join
1 2