"Lars Reineke" <reineke_at_kreiskrankenhaus-hameln.de> wrote in message
news:ak53sp$1g92i2$1_at_ID-1759.news.dfncis.de...
> Because we have ID-cards (for time registration) given out to our
employees,
> and when one employee leaves the company, his ID-card-number is deleted.
>
> When we know which one is free we can assign his former ID-card-number to
> new employees who join the company.
I think what Alan is getting at is that in most cases (and certainly yours)
there is no need to worry about gaps in the sequence. There is no reason at
all not to just use the next available number (and indeed as a former
auditor I can think of several reasons *not* to reuse time card numbers).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Aug 23 2002 - 08:25:56 CDT
