Hi Experts,
I have a table with following columns and data. Formula might be combination of any columns & calculations. Like Rate x 0.5/100 etc
Rate Qty TotFormula
10 5 Rate x Qty
10 5 Rate / Qty
10 5 Rate - Qty
My output should be something like this:
Rate Qty Result
10 5 50
10 5 2
10 5 5
Any idea how to achieve this using TSQL Query?
Query for creating sample data:
create table test
(
Rate int,
Qty int,
TotFormula varchar(50)
);
insert into test values(10,5,'Rate x Qty');
insert into test values(10,5,'Rate / Qty');
insert into test values(10,5,'Rate - Qty');
Thanks & Regards,
Naveen J V