title: Converting 1 record with a start and end date into multiple records for each day
body: <p>I'd like to know an efficient way of taking event records with a start date and end date and basically replicating that record for each day between the start and end date</p>
  
  <p>So a record with a Start Date as 2014-01-01 and End Date as 2014-01-03 would become 3 records, one for each day</p>
  
  <p>I have a date table if that helps.  I'm using SQL Server 2012 </p>
  
  <p>Thanks</p>