1
Good morning! I have a bit of a 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 given customer stops performing the box map on the day as well as in the example 1 (03-04-2018), a Nummapa(ID) is generated taking sequence from the next day on, but later he ends up having to generate so occurring what there is in the example 2 (whose day 03-04-2018 ends up with Nummapa out of sequence)...
Examples to follow: 
I wonder, if there’s any way... maybe using Row_number, I don’t know, I’d like to select the records to change Nummapa in a sequence I determine... if there’s any possibility of that. Thank you in advance.
Question: Is it really necessary to use Nummapa? If so, why? I ask because if its end is ordination, the date itself can serve you, correct?
– DiegoSantos
So Diego, the illustration was just to illustrate, in case... The accounting of such client asks me to be organized, so I do not have much choice... I can do this with updates and such, but it ends up being laborious because I have to change the day 03,04 and 05 to be correct the Nummapa... not only once, Because there is a blockage for there to be more than one identical Nummapa, I have to play a random one the next to alter the day I wish... and so on.. so I wish I could change in sequence determining according to the records searched, determine the nummapa
– Danilo Vilhena
Good afternoon, the Nummapa is the Id of the table or it is only the sequence of generation of the Datamapa?
– Wellington Araujo
Good morning! Nummapa would be the sequential generation of the Cash Maps, being as well as the Id of each one of them... I found that in the table has the key that blocks repeating the same, so much so that when I want to change some... I have to change the following to a non-existent number, so that his predecessor can assume the next number... ( que é a minha intenção realizar de uma forma fácil...)
– Danilo Vilhena