title: Find date sequence in SQL Server
body: <p>I'm trying to find the maximum sequence of days by customer in my data.
  I want to understand what is the max sequence of days that specific customer made. If someone enter to my app in the 25/8/16 AND 26/08/16 AND 27/08/16 AND 01/09/16 AND 02/09/16 - The max sequence will be 3 days (25,26,27).</p>
  
  <p>In the end (The output) I want to get two fields: custid | MaxDaySequence</p>
  
  <p>I have the following fields in my data table:
  custid | orderdate(timestemp)</p>
  
  <p>For exmple:<code>
  custid  orderdate
  1   25/08/2007
  1   03/10/2007
  1   13/10/2007
  1   15/01/2008
  1   16/03/2008
  1   09/04/2008
  2   18/09/2006
  2   08/08/2007
  2   28/11/2007
  2   04/03/2008
  3   27/11/2006
  3   15/04/2007
  3   13/05/2007
  3   19/06/2007
  3   22/09/2007
  3   25/09/2007
  3   28/01/2008
  </code></p>
  
  <p>I'm using SQL Server 2014.</p>
  
  <p>Thanks</p>