Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
How to link formula to particular variable in SQL Querry
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Pravin Ghadge
13y
1.2k
1
Reply
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.......
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
How to make exe of a web based project
Working with dynamic tabs