Re: How to get available IDs?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 17 Jan 2001 15:31:12 GMT
Message-ID: <3a65ba6a.683608297@news.alt.net>

On Wed, 17 Jan 2001 11:20:49 GMT, Thorsten Kettner <thorsten_kettner_at_my-deja.com> wrote:

>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?

How do you want the numbers returned? As a string? Each one in it's own row?

Brian Received on Wed Jan 17 2001 - 09:31:12 CST