By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| EngineId | EngineLocation | Hours | Sort | VesselID_PK | EngineSummaryID | IsActiveVesselSummary | EngineConfiguration | EngineHoursPort | EngineHoursStarboard |
|---|---|---|---|---|---|---|---|---|---|
| 111 | Port | 1000 | 1 | 1 | 111 | Y | Single | 1000 | 0 |
| 222 | Port | 2200 | 1 | 2 | 222 | Y | Twin | 2200 | 2250 |
| 90000222 | Starboard | 2250 | 2 | 2 | 222 | Y | Twin | 2200 | 2250 |
| 333 | Port | 3300 | 1 | 3 | 333 | Y | Triple | 3300 | 3350 |
| 90000333 | Starboard | 3350 | 2 | 3 | 333 | Y | Triple | 3300 | 3350 |
| 50000333 | Starboard | 3350 | 3 | 3 | 333 | Y | Triple | 3300 | 3350 |