Home Forums SQL Server 2008 SQL Server Newbies Creating a BookingDate using a random function RE: Creating a BookingDate using a random function

  • 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