On Wed, Mar 12, 2003 at 15:43:52 -0000,
"Henshall, Stuart - Design & Print" <SHenshall@westcountry-design-print.co.uk> wrote:
> Off the top of my head the only way I can see to reliably do this is
> something like the following:
Another option is to keep the number in a separate (on row) table that would be
used only when doing inserts. That way you don't have conflicts with
selects or updates to the main table.