I want to update all records in my database table with a fixed value for
pwDays and an increasing value in
My current statement:
update [POSUSER] set passDays = '60', passChangeDate = '2017-01-01 00:00:00'
But I do not want all users to have to reset their passwords on the same day. So I would like to increment the
passChangeDate by 1 day for every 10 to 20 users, is there a "simplistic" way to do this in a single SQL statement?
(All users must have a new
passChangedDate, but no more than 20 users must have the same date.)
The table has a primary key field that is a integer value. (
Note I want to only increase the date after every +/-10% users.