How to link formula to particular variable in SQL Querry

Pravin Ghadge

15y1.6k.NET

Hi friends,

I have created 1 Formula Master. In which i have created list of formulas

For Eg: B 60/60 (Hob Cabinet)=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.......

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin Ghadge15y ago
DoraBabu,

Formula Master Table

Name Formula
B 60/60 (Hob Cabinet) Height*Depth
B14(Cabinet) Height*Depth*Width

Plz help me out........
Zoran Horvat15y ago
Try with dynamic SQL. Create a variable which contains the query (which in turn contains the formula value as its part) and then execute it like this:
EXEC @query

Zoran
Dorababu Meka15y ago
Can you show some sample data of what your table contains