title: Joining Daily and Hourly data where daily data repeats for every hour
body: <p>I'm using SQL Server 2008</p>
  
  <p>I have 2 tables;<p>
  1st. <em>Currencies</em> with 2 Columns: Date, USD (daily data)</p>
  
  <p>Sample Data:</p>
  
  <pre><code>  
  Date        USD     
  2009-12-01  1,5005  
  2009-12-02  1,4898  
  2009-12-03  1,4802  
  2009-12-04  1,4757  
  </code></pre>
  
  <p>2nd. Prices with 2 Columns: Date,Price (Hourly data)<p>
  Sample Data:</p>
  
  <pre><code>  
  
  
  Date                   Price
  2009-12-01 00:00:00    169,44   
  2009-12-01 01:00:00    139  
  2009-12-01 02:00:00    70   
  2009-12-01 03:00:00    65,89    
  2009-12-01 04:00:00    66,47    
  </code></pre>
  
  <p>What i want is joining these tables with data for every hour like:</p>
  
  <pre><code>  
  Date                   Price       USD
  2009-12-01 00:00:00    169,44   1,5005  
  2009-12-01 01:00:00    139      1,5005  
  2009-12-01 02:00:00    70       1,5005  
  2009-12-01 03:00:00    65,89    1,5005  
  2009-12-01 04:00:00    66,47    1,5005  
  </code></pre>
  
  <p>Thanks.</p>