Hi Dwain,

I didn't mean to offend you, if that's the case I am sorry. My boss helped me with that query, is it not right?

1.35 Million Records of which

30% should 2 night stays

20% should be 3 night stays

and the other 50% to be randomised between 1, 4 and 28 days.

I do have another question if you could help in the same vain.

I now need to make 15% of them cancelled by inserting a random Cancelled Date. However the cancelled date must be =>Booking Date and <=Arrival Date.

I have completed the random section but I now need to know how to add greater than and less than part to the query:

Can you help?

SELECT ArrivalDate,

DATEADD(day,

CASE WHEN Rand(CHECKSUM(NEWID())) BETWEEN 0 and 0.85 THEN NULL ELSE

CASE WHEN Rand(CHECKSUM(NEWID())) BETWEEN 0.85 and 0.88 THEN 0 ELSE

CASE WHEN Rand(CHECKSUM(NEWID())) BETWEEN 0.88 and 0.92 THEN -1 ELSE

CASE WHEN Rand(CHECKSUM(NEWID())) BETWEEN 0.92 and 0.97 THEN -7 ELSE

Round(Rand(CHECKSUM(NEWID())) * -90,0) END END END END,ArrivalDate) AS DaystoReduce

FROM Bookings

Thanks

Wayne