Hi Guys,

I have a table that stores the last no. generated by the previous transactions. Is it possible to get the next number then update the table with the new number using stored procedure?

Can you please give me an example of how to do it properly.

Thanks in advance...