CREATE DEFINER="root"@"%" PROCEDURE "srcProc"(IN var_fkProfile BIGINT, IN var_Weekday ENUM('0', '1', '2', '3', '4', '5', '6') )
BEGIN
	DECLARE var_BMR_Formula TINYINT UNSIGNED;
    DECLARE var_BMR_Value SMALLINT UNSIGNED;
    DECLARE var_ActivityLevel TINYINT UNSIGNED;
    DECLARE var_CaloriesBurned SMALLINT UNSIGNED;
    DECLARE var_WeekGoal TINYINT UNSIGNED;
    DECLARE var_GoalCaloriesDelta SMALLINT;
    DECLARE var_CarbsGoalInPercent TINYINT UNSIGNED;
    DECLARE var_ProteinsGoalInPercent TINYINT UNSIGNED;
    DECLARE var_FatGoalInPercent TINYINT UNSIGNED;
SELECT 
    BMR_Formula,
    BMR_Value,
    ActivityLevel,
    CaloriesBurned,
    WeekGoal,
    GoalCaloriesDelta,
    CarbsGoalInPercent,
    ProteinsGoalInPercent,
    FatGoalInPercent
INTO var_BMR_Formula , var_BMR_Value , var_ActivityLevel , var_CaloriesBurned , var_WeekGoal , var_GoalCaloriesDelta , var_CarbsGoalInPercent , var_ProteinsGoalInPercent , var_FatGoalInPercent FROM
    NutritionGoal
WHERE
    NutritionGoal.Weekday = var_Weekday;
SELECT 
    var_BMR_Formula,
    var_BMR_Value,
    var_ActivityLevel,
    var_CaloriesBurned,
    var_WeekGoal,
    var_GoalCaloriesDelta,
    var_CarbsGoalInPercent,
    var_ProteinsGoalInPercent,
    var_FatGoalInPercent;
    
UPDATE NutritionGoal 
SET 
    BMR_Formula = var_BMR_Formula,
    BMR_Value = var_BMR_Value,
    ActivityLevel = var_ActivityLevel,
    CaloriesBurned = var_CaloriesBurned,
    WeekGoal = var_WeekGoal,
    GoalCaloriesDelta = var_GoalCaloriesDelta,
    CarbsGoalInPercent = var_CarbsGoalInPercent,
    ProteinsGoalInPercent = var_ProteinsGoalInPercent,
    FatGoalInPercent = var_FatGoalInPercent
WHERE
    fkProfile = var_fkProfile;
END