Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql =================================================================== diff -u -r33d80f2fbc1d5c535837caec95ccf7a550170292 -ra64b58baad3ab75c0a52c1f41d6d7799387d535e --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision 33d80f2fbc1d5c535837caec95ccf7a550170292) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision a64b58baad3ab75c0a52c1f41d6d7799387d535e) @@ -1270,9 +1270,7 @@ INSERT INTO TempLogOutputDeleted SELECT COUNT() FROM [SOURCEPROJECT].StabilityStoneCoverWaveConditionsOutputEntity; INSERT INTO TempLogOutputDeleted SELECT COUNT() FROM [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsOutputEntity; INSERT INTO TempLogOutputDeleted SELECT COUNT() FROM [SOURCEPROJECT].ProbabilisticPipingCalculationOutputEntity; -INSERT INTO TempLogOutputDeleted -SELECT COUNT() -FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationOutputEntity +INSERT INTO TempLogOutputDeleted SELECT COUNT() FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationOutputEntity WHERE SemiProbabilisticPipingCalculationEntityId IN ( SELECT SemiProbabilisticPipingCalculationEntityId FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationEntity @@ -1282,9 +1280,7 @@ ( 'NrRemaining' INTEGER NOT NULL ); -INSERT INTO TempLogOutputRemaining -SELECT COUNT() -FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationOutputEntity +INSERT INTO TempLogOutputRemaining SELECT COUNT() FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationOutputEntity WHERE SemiProbabilisticPipingCalculationEntityId IN ( SELECT SemiProbabilisticPipingCalculationEntityId FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationEntity