Date Randomise

[wafw1971]

I have a Arrival date of 01/01/2012 the Departure date can be any date between 02/01/2012 and 29/01/2012 and needs to added to the database either via an Update/Insert Statement. Can you help with the code.SELECT ArrivalDate, DATEADD(day, RAND(checksum(NEWID()))* LengthOfStay.LengthofStay, ArrivalDate) AS DepartureDate FROM Bookings, LengthOfStayORDER BY ArrivalDateBut the Departure date cannot be the same as the arrival date.Thanks

[justsomeguy]

You just need to make sure you're adding at least one day to the arrival date, but that query doesn't look correct with regard to the length of stay value. You're telling it to get that from the other table but you're not telling it which row to get it from, it's going to always use the value from the first row.