title: Get the SUM of TIME datatypes (MSSQL08) from a table
body: <p>I have the following table of TIME datatypes</p>
  
  <p>clarification: I am representing hours/mins/seconds of videos and want to figure out how long the videos will be.</p>
  
  <pre><code>runtime
  ----------------
  01:27:19.0000000
  01:26:09.0000000
  01:00:56.0000000
  01:09:59.0000000
  01:25:43.0000000
  01:16:01.0000000
  01:27:12.0000000
  01:22:00.0000000
  01:17:47.0000000
  01:31:07.0000000
  01:36:23.0000000
  01:13:29.0000000
  01:20:12.0000000
  01:03:24.0000000
  00:58:42.0000000
  </code></pre>
  
  <p>I want to get the SUM of all of these times.</p>