Table structure to store mathmatical formula in SQL Server

Question

Hi All Could you please suggest the table structure to store the below formula: Amount Formula Field A Field B Field C Field D Field E Field F Field G Dropdown with options Operand Dropdown with options Operand Text Value Operand Text Value Thanks in advance. Vinay

Khaja Moizuddin · Answer

Please Refer these blogs. http://dba.stackexchange.com/questions/33894/store-a-formula-in-a-table-and-use-the-formula-in-a-function http://softwareengineering.stackexchange.com/questions/290114/what-is-the-best-way-to-store-a-formula-in-a-database-for-a-table-driven-formula?rq=1 http://stackoverflow.com/questions/25283636/store-a-formula-in-a-table-and-use-it-for-future-calculations http://searchoracle.techtarget.com/answer/Storing-and-retrieving-mathematical-formulas https://www.codeproject.com/questions/495161/howplustoplusstoreplusmathplusformulaplusinplussql https://www.codeproject.com/questions/866751/how-to-insert-mathematical-and-chemical-equation-i Hope this helps you.