Home Forums SQL Server 2008 SQL Server Newbies Creating a BookingDate using a random function RE: Creating a BookingDate using a random function
wafw1971
SSC Eights!
Points: 976
More actions
February 20, 2013 at 5:30 am
#1589509
Its alright I have figured it out:
SELECT ArrivalDate, DATEADD(day, -1 + RAND(checksum(NEWID()))*-90
, ArrivalDate) AS BookingDate
FROM Bookings
ORDER BY ArrivalDate