Populating a Booking date usind dateadd

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Populating a Booking date usind dateadd

Author

Topic

wafw1971
Yak Posting Veteran

75 Posts

Posted - 2013-02-20 : 07:16:40

I have an arrival date already in the system and I need to populate the Booking date using a random function, the booking date can be any day on or before the arrival date up to a maximum 90 days previous but it must be random the booking date cannot all be the same date.

I thought I cracked it but was wrong. Can you help?

SELECT ArrivalDate, DATEADD(day, -1 + RAND(checksum(NEWID()))-90
, ArrivalDate) AS BookingDate
FROM Bookings
ORDER BY ArrivalDate

Thanks

Wayne

wafw1971
Yak Posting Veteran

75 Posts

Posted - 2013-02-20 : 07:31:23

Its alright I have figured it out:

SELECT ArrivalDate, DATEADD(day, -1 + RAND(checksum(NEWID()))*-90
, ArrivalDate) AS BookingDate
FROM Bookings
ORDER BY ArrivalDate

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources