Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql =================================================================== diff -u -r2b5a0d60bbd4fdabaa3daf275996015548aa39d6 -rf44ed31a52e0edd9c33e7207a59818b82cbdb598 --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 2b5a0d60bbd4fdabaa3daf275996015548aa39d6) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision f44ed31a52e0edd9c33e7207a59818b82cbdb598) @@ -325,7 +325,6 @@ JOIN TempHydraulicLocationCalculationEntity USING (HydraulicLocationEntityId); -- Perform the migration of the output entities - INSERT INTO HydraulicLocationOutputEntity ( [HydraulicLocationOutputEntityId], [HydraulicLocationCalculationEntityId], @@ -354,19 +353,10 @@ JOIN [SOURCEPROJECT].HydraulicLocationEntity hl ON hlo.HydraulicLocationEntityId = hl.HydraulicLocationEntityId JOIN TempHydraulicLocationCalculationEntity USING (HydraulicLocationEntityId) JOIN AssessmentSectionEntity USING (AssessmentSectionEntityId) -WHERE NormativeNormType = 2; +WHERE NormativeNormType = 2 +UNION -INSERT INTO HydraulicLocationOutputEntity ( - [HydraulicLocationOutputEntityId], - [HydraulicLocationCalculationEntityId], - [GeneralResultSubMechanismIllustrationPointEntityId], - [Result], - [TargetProbability], - [TargetReliability], - [CalculatedProbability], - [CalculatedReliability], - [CalculationConvergence]) SELECT [HydraulicLocationEntityOutputId], CASE WHEN [HydraulicLocationOutputType] = 1 @@ -436,7 +426,6 @@ WHERE NormativeNormType = 1 AND hle.ShouldWaveHeightIllustrationPointsBeCalculated = 1 ); - -- Cleanup DROP TABLE TempHydraulicLocationCalculationEntity;