title: MS SQL Join on dateTime
body: <p>I have a query that joins two tables.
  The join is done on several columns, including a dateTime column.
  The problem that I have at the moment is that the one dateTime column stores milliseconds whereas the other table is populated from a file which does not contain milliseconds
  Because of this the join will never return results.</p>
  
  <p>Is there any way via SQl to ignore the milliseconds?</p>