title: How to design/create rules table with criteria in SQL Server 2008
body: <p>I don't have much experience with SQL Server and I'm pretty much lost when it comes to anything more advanced than simple <code>INSERT/SELECT</code> statements.</p>
  
  <p>My task is to create table which hold 'criteria' (rules) for other tables in same DB. I mean we have an <code>Employee</code> table, a <code>Salary</code> table etc. I need to make some rules between <code>Employee</code> table and <code>Salary</code> table by its values, i.e. if <code>Employee = John</code> and <code>Salary = 2000</code> then make 1 criteria, if <code>Employee = Steve</code> and <code>Salary = 3000</code> then make 2 criteria.</p>
  
  <p>I have created a table called <code>Rules</code>:</p>
  
  <pre><code>RuleID    Criteria
  --------------------------------------------------    
  1         Employee = John and Salary = 2000
  2         Employee = Steve and Salary = 3000**
  </code></pre>
  
  <p><strong>My question</strong>: As mentioned above is correct way to create 'criteria' table? (maybe I have 50 different conditions...Would it be correct way If I create table with all conditioned as mentioned above?) Please advise.</p>
  
  <p>I am sorry If I am not able to explain it in correct way or asking basic question.</p>
  
  <p>I would appreciate any help in this. Thanks a lot in advance..</p>