UPDATE [dbo].[AutonomousScalingRecommendations]
SET [TargetService] = @TargetService, [TargetResource] = @TargetResource, [ActionType] = @ActionType, [CapacityDelta] = @CapacityDelta, [Confidence] = @Confidence, [Reason] = @Reason, [MetricSummary] = @MetricSummary, [RequiresApproval] = @RequiresApproval, [Status] = @Status, [CreatedAtUtc] = @CreatedAtUtc, [LastUpdatedAtUtc] = @LastUpdatedAtUtc, [ApprovedAtUtc] = @ApprovedAtUtc, [ApprovedBy] = @ApprovedBy, [ExecutedAtUtc] = @ExecutedAtUtc, [ExecutionMessage] = @ExecutionMessage
    OUTPUT INSERTED.*
WHERE [Id] = @Id;
