sno value1 value2 1 10000 11500 2 12000 13500
select value1,value2,cast(((value1-value2)/value2)*100 as float) as Value3 from table1
value1 value2 value3 10000 11500 0 12000 13500 0
98.2,95.3
declare @v1 decimal(10,2), @v2 decimal(10,2) set @v1 = 10000 set @v2 = 13500 select @v1 ,@v2 ,cast(((@v1-@v2)/@v2)*100 as decimal(5,2))
Select value1, value2, ((CONVERT(DECIMAL(10,2),VALUE1) - CONVERT(DECIMAL(10,2),VALUE2)) / (CONVERT(DECIMAL(10,2),VALUE2)))*100 as VALUE3 from table1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)