title: DB persist from-to value in SQL server
body: <p>I'm currently working on a DB design in SQL Server 2016.</p>
  
  <p>Given is the following table <code>tProjects</code>:</p>
  
  <pre><code>Column Name | Data Type    | Allow Nulls
  --------------------------------------
  PID         | int          | no
  Title       | varchar(255) | no
  Price       | money        | yes
  </code></pre>
  
  <p>So far so good, the problem is the following:</p>
  
  <p><em>I need to somehow persist the price range (value range) priceFrom and priceTo.</em></p>
  
  <p>Do you know how to create a relation to persist the from - to values in a table in my DB and reference this these range prices in my table tProjects?</p>
  
  <p>Thank you very much!!</p>