However, having the sequence restart at 1 for each unique value of A (a new UPC) allows us to store F in a smallint, which saves us almost 10% of space per observation over forcing F to be unique.

I am trying to write a query that shows me how much I sold to every customer every day over the last 60 days. I want a day represented in my resulting dataset even if there were no sales on that ...