Creating a Non-Sequential Order Number System based on Microsoft SQL Server
(Noah Subrin) Some e-commerce systems employ a sequential order numbering scheme. In some scenarios this design is not desirable. . I worked for an e-commerce company that did not want its order volume available to competitors, and used a system that generated sequential order numbers. A competitor could place an order first thing in the morning and another order at the end of the day. By subtracting the first order number from the last order number, one could derive a close estimate of the actual orders generated. I was tasked with creating a non-sequential ordering system.

Read More >>