Post Author: despec
CA Forum: Data Connectivity and SQL
Given the following table, can anyone poin tme in the right direction on the SQL code needed to count the consecutive dates: Student Name Date AbsentSmith, Joe 5/9/2008Smith, Joe 5/8/2008Smith, Joe 5/7/2008Smith, Joe 5/6/2008Smith, Joe 5/5/2008Smith, Joe 5/2/2008Smith, Joe 5/1/2008Smith, Joe 4/30/2008Smith, Joe 4/15/2008 I've been fighting with this for days, and I think I need to use derived tables, but if anyone can point me in the right direction, I'll include you in my will 😊 David