Re: How to get available IDs?

From: Thorsten Kettner <thorsten_kettner_at_my-deja.com>
Date: Wed, 17 Jan 2001 11:20:49 GMT
Message-ID: <943v6d$kiu$1@nnrp1.deja.com>

Hi Brian. Available means not yet used. This is why I subtract the set of all emp_no that I can find in table emp from the set of all available numbers (0 to 999). If I have three emploees with emp_no 1, 2 and 4 I want to get the numbers 0,3,5,6,7 and so on to 999. Do you have a better solution than the way I have used?

To all the others reading this: Please see my original question to see it in complete.

---

In article <3a646ea6.598676125_at_news.alt.net>,   SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) wrote:
> On Tue, 16 Jan 2001 15:08:00 GMT, Thorsten Kettner
> <thorsten_kettner_at_my-deja.com> wrote:
>
> >Hi, I think this is a beginner's question: I want to get all
 available
> >employee numbers by sql to put new employees into the system. If
 emp_no
> >is NUMBER(3) then this is how I do it:...
>
> What defines an employee number as being "available"?
>
> Brian
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 05:20:49 CST