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]
