Comments by Rogue258 (Top 1 by date)

@Wendelius colR comes from some other Query which has its own tables (table_F, table_J,table_k etc). The reason that I am not doing this for all the values and doing a check is because calculating colR for all the values of colP, every time would require a lot of computation (colR is calculated from tables which have 300-400 million rows and 60-100 columns). Since this will be a daily task, and the values of colR won't change once calculated, I did not want it to repeat for already present. Thank you for your solution.