>I need to generate a next number value from a SQL Server table. I need to ensure that the number is unique and that another user doesn't retrieve the same value from the next number table.
>
>What is the best way to generate a next number value from a SQL Server table?

Did you consider using IDENTITY column? Check Re: Record ID generator question Thread #605839