Good morning! I have a rather boring situation here at work ... I would like an idea to solve this problem.
There is a case that often happens that is basically the following, When a client fails to perform the cash map on the day as in example 1 (03-04-2018), a NumMap (ID) is generated taking sequence of the next day, but later it ends up having to generate like this happening what there is in example2 (whose day 03-04-2018 ends up with NumMapa out of sequence) ...
Examples below: 
I would like to know if there is any way ... maybe using Row_Number, I do not know, I'd like to select the records to change the NumMap into a sequence that I determine ... if there is any possibility of this. Thank you in advance.