Stock break for 5 consecutive days

[andrefpc]

Hello community,

I'm struggling whith what seems to be a simple requirement.

I have a table with ArticleID, Date, Stock break date.

I need to count ArticleIDs where there was a stock break for more thank 5 consecutive days.

Thanks in advance.

[sujeetsingh]

Costa,

Can you please provide a sample data set for this requirement. Well you can use group by to find the stock break count and then get the desired output.