Generating Next numbers in SQLServer should not be a problem. But problems arise when a customer asks for different types of Next numbers that you cannot generate directly from SQL Server. This brief article describes how you would tackle this problem in different scenarios.
