Sorry guys, but I dont understand how to implement it via SQL server....:w00t:

Hi Sean,

Can u provide to me an example, pls?

In Italy the tax office requires a complete seq. number for invoices 🙁

But I'd recover that invoice number not to void

:ermm:

Hi Lynn,

I considered this option, but it could be other problem of concurrency.

Imagine I have two record of with invoice Nr not completed, ie

InvoiceID flagcompleted

1 ...

This is an example in pseudo code about what I am worried.

USER 1

--my invoice Number = mysequence = 1

SELECT

mysequence = NEXT VALUE FOR dbo.MySequence;

GO

begin trans

insert into table1...

Hi SSChampion,

you are right, indeed my problem with my strategy is in case of same rollback.

I am storing pointer to nextrows

SET @nextNumReg = (SELECT [RelNumReg] + 1.....

cause I need to...

Hello guy,

Yes, i have evaluated to work with sequence, but there are some limitation , ie. Sequence numbers inserted into a table can have gaps when a transaction is rolled...

Hi Lowell,

thanks for your reply.

Indeed it is the application that has to assign the purchase order number, the solution you suggest is to create a table with Identity and after...