July 19, 2011 at 8:57 am
Hi there,
We running into a formula calculation problem using sql server.
Description : We store formula as a+b+c/e in a column in table A
in table B when I need to store the value from columns a,b,c,e from table B using the expression from table A.
When i declare a variable @test-2 = formula from table A
select x = @test-2 from table B -- it throws an exception
but if If I do select x = a+b+c/e from table B -- it returns a value
is there way to achieve this ???
Thanks in advance for all the help
July 19, 2011 at 9:06 am
Dynamic SQL 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 19, 2011 at 9:08 am
Can you give an example or something to use...thanks in advance
July 19, 2011 at 9:11 am
and also this formula changes from time to time
July 19, 2011 at 9:16 am
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply