Query to find first missing integer in a field
From: dean <deanbrown3d_at_yahoo.com>
Date: Tue, 7 Apr 2009 12:51:06 -0700 (PDT)
Message-ID: <27d83f59-6f5d-4598-bf9c-d1a1326caa57_at_l1g2000yqk.googlegroups.com>
Does anyone know a good way to find the first free integer number that does not exist in a table in a specified column? I can think of a couple of tedious ways of doing this but they are hardly elegant. Assume there could be any integer present up to 2 billion. Received on Tue Apr 07 2009 - 14:51:06 CDT
Date: Tue, 7 Apr 2009 12:51:06 -0700 (PDT)
Message-ID: <27d83f59-6f5d-4598-bf9c-d1a1326caa57_at_l1g2000yqk.googlegroups.com>
Does anyone know a good way to find the first free integer number that does not exist in a table in a specified column? I can think of a couple of tedious ways of doing this but they are hardly elegant. Assume there could be any integer present up to 2 billion. Received on Tue Apr 07 2009 - 14:51:06 CDT