From: RG on
We seem to have hit an oddity.

We have a stored procedure that gets the next sequence number. It is
protected by a transaction so no two processes could update the table of ids
at the same time. Every so often, we get duplicates. How could that happen?
Is the value based on mantissa? If so, is there a way to expanded it?

Keep in mind, I can't change the type from float.

Any help is greatly appreciated.

Thanks in advance
From: Jeroen Mostert on
On 2010-07-19 16:19, RG wrote:
> We seem to have hit an oddity.
>
Please don't multi-post. If you have to post to multiple newsgroups, post to
all of them at once.

Followup to microsoft.public.sqlserver.programming.

--
J.