title: Distinct random time generation in the fixed interval
body: <p>I'm trying to generate a random time between 8:00 AM and 8:00 PM <em>for each row</em> that is selected from a data set, however, I always get the <strong><em>same</strong> random value for each row</em> – I want it to be <strong><em>different</strong> for each row</em>.</p>
  
  <p><em>Table schema &amp; data:</em></p>
  
  <pre class="lang-none prettyprint-override"><code>╔══════╦════════════════╗
  ║  ID  ║  CREATED_DATE  ║
  ╠══════╬════════════════╣
  ║ ID/1 ║   26/04/2014   ║
  ║ ID/2 ║   26/04/2014   ║
  ║ ID/3 ║   26/04/2014   ║
  ║ ID/4 ║   26/04/2014   ║
  ║ ID/5 ║   26/04/2014   ║
  ╚══════╩════════════════╝
  </code></pre>
  
  <p><em>Сurrent SQL statement:</em></p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT [ID]
       , MyFunction.dbo.AddWorkDays(14, [CREATED_DATE]) AS [New Date]
       , CONVERT(VARCHAR, DATEADD(MILLISECOND, CAST(43200000 * RAND() AS INT), CONVERT(TIME, '08:00')), 114) AS [New Time]
  FROM [RandomTable]
  </code></pre>
  
  <p><em>Current results (<strong>same</strong> time for each row in the <code>[New Time]</code> column):</em></p>
  
  <pre class="lang-none prettyprint-override"><code>╔══════╦════════════════╦════════════════╗
  ║  ID  ║    New Date    ║    New Time    ║
  ╠══════╬════════════════╬════════════════╣
  ║ ID/1 ║   10/05/2014   ║    09:41:43    ║
  ║ ID/2 ║   10/05/2014   ║    09:41:43    ║
  ║ ID/3 ║   10/05/2014   ║    09:41:43    ║
  ║ ID/4 ║   10/05/2014   ║    09:41:43    ║
  ║ ID/5 ║   10/05/2014   ║    09:41:43    ║
  ╚══════╩════════════════╩════════════════╝
  </code></pre>
  
  <p><em>Desired results (<strong>different</strong> time for each row in the <code>[New Time]</code> column):</em></p>
  
  <pre class="lang-none prettyprint-override"><code>╔══════╦════════════════╦════════════════╗
  ║  ID  ║    New Date    ║    New Time    ║
  ╠══════╬════════════════╬════════════════╣
  ║ ID/1 ║   10/05/2014   ║    09:41:43    ║
  ║ ID/2 ║   10/05/2014   ║    15:05:23    ║
  ║ ID/3 ║   10/05/2014   ║    10:01:05    ║
  ║ ID/4 ║   10/05/2014   ║    19:32:45    ║
  ║ ID/5 ║   10/05/2014   ║    08:43:15    ║
  ╚══════╩════════════════╩════════════════╝
  </code></pre>
  
  <p>Any ideas on how to fix this? All of the above is just sample data – my real table has around 2800 records (<em>not sure if that will make a difference to anyone's suggestions</em>).</p>