Koen Verbeeck (10/22/2014)

---

You can add a row number to each line with ROW_NUMBER(). Filter on non-zero quantities and get the minimum row number. Substract this from the maximum row...

The output of the sample data set in question should be 5.

Thanks for the help. 😎