title: Why isn't this INSERT with DATEDIFF statement working right?
body: <pre><code>INSERT INTO timecrunch.dbo.intervals (IntervalID, Duration) 
  SELECT ixInterval, DATEDIFF(hour, dtStart, dtEnd) FROM fogbugz.dbo.TimeInterval
  WHERE dtEnd is not NULL
  </code></pre>
  
  <p>IntervalID is an int, Duration is a float</p>
  
  <p>I am trying to put all the hourly durations into the Duration column... I assume that even if it is less than an hour it will use a fraction which is why I put a float?</p>
  
  <p>Help.</p>
  
  <p>PS: It's running fine no errors, but after it's done the intervals table is still empty... I know the data is in the TimeInterval table though...</p>