=Height*Depth
I have used foll querry to calculate calculation.
declare @Depth as numeric(18,2)
declare @Height as numeric(18,2)
declare @Area as numeric(18,2)
declare @Formula as varchar(100)
set @Depth=100
set @Height=100
Set @Formula=(Select Formula from [formula_master] where [name] = ('B 60/60 (Hob Cabinet)'))
select @Formula
if(@formula=(Select Formula from [@formula_master] where [name] = ('B 60/60 (Hob Cabinet)')))
begin
set @LPR=@formula
Select @LPR
end
Plzzzz help me out.......