title: TSQL to combine a date field and a time field
body: <p>Using logparser to import IIS logs to a db results in one column that has the date value and a second field for time:</p>
  
  <pre><code>2010-05-25 00:00:00.000
  </code></pre>
  
  <p>and</p>
  
  <pre><code>2010-01-01 11:11:58.000
  </code></pre>
  
  <p>I'd like to code an <code>after insert</code> trigger that combines the 2 fields. </p>