title: How to combine date from one field with time from another field - MS SQL Server
body: <p>In an extract I am dealing with, I have 2 <code>datetime</code> columns. One column stores the dates and another the times as shown.</p>
  
  <p>How can I query the table to combine these two fields into 1 column of type <code>datetime</code>?</p>
  
  <p><strong>Dates</strong></p>
  
  <pre><code>2009-03-12 00:00:00.000
  2009-03-26 00:00:00.000
  2009-03-26 00:00:00.000
  </code></pre>
  
  <p><strong>Times</strong></p>
  
  <pre><code>1899-12-30 12:30:00.000
  1899-12-30 10:00:00.000
  1899-12-30 10:00:00.000
  </code></pre>