Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khufiamalik
Posting Yak Master
120 Posts |
 Posted - 2008-09-01 : 00:50:39
|
| Hello All,I have to create a table which will contain my business rules.like House Rent will be 60% of Basic Salary.one option is to have a field in that table, which will contain a complete Query.like Select BasicSalary*60/100 from EmployeeSalaryTable where EmployeeID=?. The Value Against ? mark will be pasted from SP which will call this ruleBut I have been asked to do some thing else.Now I want to make a 'configuration' table which can contain the definition of my rule.Can Any one help me in this regard that what should be the structure of my table?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-01 : 10:14:03
|
| It is a very bad design to store queries in a table. Could you show us other business rules so that we can figure out if a table would be the best place for this data?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
How to create a Rule Table