How to interpret values of a column which in turn contains name other columns?

[robert_volk]

This may help:

(SOLVED)Stored Procedure that will replaced and compute Dynamic Formula saved in a column

-- create table defs and populate data CREATE TABLE Table_Formula(id int not null PRIMARY KEY, country varchar(20) not null, Formula varchar(100) not null); INSERT Table_Formula VALUES (1,'Germany','[AMOUNT]*(1+[FEE])*(1+[MAIN])') ,(2,'India','[AMOUNT]*(1+[MAIN])') ,(3,'Korea','[AMOUNT]*(1+[FEE])*(1+[SUB])'); CREATE TABLE Table_Rate(id int not null PRIMARY KEY, country varchar(20) not null , Category_1 varchar(10) not null, Value_1 money not null , Category_2 varchar(10) null, Value_2 money n…