title: Weighting a length of time to get a different Date each time
body: <p>I have an arrival Date 01/01/2010, this has occurred 50 times and I want to randomise 50 departure dates using the length of stay weighting guide below, as you can the majority of these will leave 2 days later, but I cannot figure out how to write the code, Can you help.</p>
  
  <pre><code>LengthofStay LengthofStayWeighting
  ------------ ---------------------
  1            1
  2            5
  3            4
  4            3
  5            3
  6            3
  7            3
  8            1
  9            1
  10           1
  </code></pre>
  
  <p>I have started but have got stuck already</p>
  
  <pre><code>SELECT ArrivalDate,RAND(checksum(NEWID())) * LengthOfStay.LengthofStayWeighting AS Expr1, 
  ArrivalDate + Expr1 as DepartureDate
  
  FROM Bookings, LengthOfStay
  ORDER BY ArrivalDate
  </code></pre>