title: Interpolating Data from Multiple Parameter SQL Query
body: <p>I have a database of settings for a machine that has the following parameters:</p>
  
  <p>Outer Diameter (OD) | Inner Diameter (ID) | Power | Speed | Dwell</p>
  
  <p>When using a new material size I want to interpolate the settings from the closest values in order to minimize the adjusting I need to do for new material. </p>
  
  <p>Given a OD and ID that doesn't exist in the database what is the best way to query the database for the closest value > and &lt; the OD and ID combination and from those values interpolate the settings for the new size.</p>