Skip to Content
0
Former Member
May 12, 2008 at 07:02 PM

Counting consecutrive dates in a range

38 Views

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