Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql =================================================================== diff -u -r6698fe75e6ecebbb7d7e8ebed2e8011b74a3274a -r4466f27bca1f0a2a16dd491ffe73bb9d72934a56 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision 6698fe75e6ecebbb7d7e8ebed2e8011b74a3274a) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision 4466f27bca1f0a2a16dd491ffe73bb9d72934a56) @@ -127,10 +127,11 @@ [LowerBoundaryWaterLevels], [StepSize], [CalculationType], - CASE WHEN [CategoryType] = 4 - THEN 2 - ELSE - 1 + CASE + WHEN [CategoryType] = 4 + THEN 2 + ELSE + 1 END FROM [SOURCEPROJECT].GrassCoverErosionOutwardsWaveConditionsCalculationEntity; INSERT INTO GrassCoverSlipOffInwardsSectionResultEntity SELECT * FROM [SOURCEPROJECT].GrassCoverSlipOffInwardsSectionResultEntity; @@ -256,12 +257,13 @@ [LowerBoundaryWaterLevels], [StepSize], [CalculationType], - CASE WHEN [CategoryType] = 2 - THEN 3 + CASE + WHEN [CategoryType] = 2 + THEN 3 WHEN [CategoryType] = 3 THEN 2 - ELSE - 1 + ELSE + 1 END FROM [SOURCEPROJECT].StabilityStoneCoverWaveConditionsCalculationEntity; INSERT INTO StochastEntity SELECT * FROM [SOURCEPROJECT].StochastEntity; @@ -327,12 +329,13 @@ [UpperBoundaryWaterLevels], [LowerBoundaryWaterLevels], [StepSize], - CASE WHEN [CategoryType] = 2 - THEN 3 + CASE + WHEN [CategoryType] = 2 + THEN 3 WHEN [CategoryType] = 3 - THEN 2 + THEN 2 ELSE - 1 + 1 END FROM [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsCalculationEntity;