SQL Server - How to perform a calculation based on a dynamic formula -

-

i have case need perform dynamic calculation based on particular entry in column.

the table looks like:

declare temp table (         id int,          name nvarchar(255),         const1 decimal(18,10),         const2 decimal(18,10),         const3 decimal(18,10),         const4 decimal(18,10)     );

i want add in field called "calculation". user has specify in field how constants applied (i.e. "const1 * const2 + (const3 - const4)").

i've got function has formula hard coded want able dynamically map table columns "calculation" field. possible? if i'm getting table entry like:

id| name         | const1 | const2 | const3 | const4 | calculation 1 | calculation1 |      5 |      3 |      2 |      9 | const1 * const2 + (const3 - const4)

then in function, can dynamically make calculation , return output? approaching problem correct way?

thanks in advance!

you'll need use dynamic sql sp_executesql or exec. don't recall if can used in udf or not , there issues aware of, such sql injection , possible performance issues. don't have time test whether or not works in udt, want like:

declare @sql varchar(max)  select @sql = 'select ' + replace(replace(calculation, 'const1', const1), 'const2', const2)... + ' result' my_table id = 1  exec(@sql)

Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di...
Read more

css - Can I use the :after pseudo-element on an input field? -

-
i trying use :after css pseudo-element on input field, not work. if use span , works ok. <style type="text/css"> .mystyle:after {content:url(smiley.gif);} .mystyle {color:red;} </style> this works (puts smiley after "buu!" , before "some more") <span class="mystyle">buuu!</span>a more this not work - colors somevalue in red, there no smiley. <input class="mystyle" type="text" value="somevalue"> what doing wrong? should use pseudo-selector? note: cannot add span around input , because being generated third-party control. :after , :before not supported in internet explorer 7 , under, on elements. it's not meant used on replaced elements such form elements (inputs) , image elements . in other words it's impossible pure css. however if using jquery can use $(".mystyle").after("add smiley here"); api docs on .after to ...
Read more