title: Generate random SQL Server 2008 time test data
body: <p>I am trying to generate a large data set which includes time datatype in SQL Server 2008.  I already have some non-time data in a table so I'd like to keep the entire process in T-SQL and use an insert-into-select to get the partial data from one table and insert it into the next along with some generated data including the time.  </p>
  
  <p>I'd like a way to generate random time(7)s between two points, say a random time between 8:00 and 9:00.  I've found some pre-2008 post but nothing that addresses SQL Server 2008's time type.  </p>