Feb 16/2014 Create Unique Invoice Number in SQL A better solution will have a separate table so you can generate Invoice numbers. This way you let IDENTITY field work for you with any Insert as shown in the below Stored Procedure.