Finding missing orders with a recursive CTE

When a paid order vanished from our database, I used a SQL recursive CTE to bridge the gap in our unconventional numbering system and track down the missing record.

Finding missing orders with a recursive CTE

Marginalia