Good day,



I have a question for you SQL boffins, how can I query a table to get the
count of consecutive days found ?



A Table contains rows with dates where an item(s) has been added for every
day this item was used.



i.e.



itemnr dateused

abc 2017/02/01

abc 2017/02/02

abc 2017/02/25

abc 2017/02/25

abc 2017/02/25

abc 2017/02/26

abc 2017/02/27

abc 2017/02/28

abc 2017/03/01

abc 2017/03/02



The result from above sample should be 6 as there is a break between
2017/02/02 and 2017/02/25?



Regards



Stef



[Non-text portions of this message have been removed]