Hi Dwain

I have tried to breakdown what I need below, I hope this helps.

Thanks

Wayne

Step 1

Arrival Date (Already generated) – 1.35 Million Times

Step 2

Randomise a number between 0 and 1

Step 3

Use the Randomised number produced above to create the script below

UPDATE BOOKINGS

SET DepartureDate

CASE WHEN RAND() Result = Between 0 and 0.3 = Departure Date will be 2 Nights Later

CASE WHEN RAND() Result = Between 0.3 and 0.4 = Departure Date will be 3 Nights Later

CASE WHEN RAND ()Result >0.4 = Departure Date will be either 1,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28 Nights Later