Urgent: 8 Consecutive days worked

• kotteesh

  SSC Journeyman

  Points: 83

  More actions

  June 28, 2011 at 12:21 am

  #242869

  Hi All,

  I have table with columns:

  [ASSOCIATEID]

  [LASTNM]

  [FIRSTNM]

  [STRNBR]

  [DPTNBR]

  [TYPE]

  [DateWorked] [datetime] NULL,

  [HoursWorked].

  Need to report like this :

  Associate number

  Associate name

  Date worked

  number of hours worked each day

  Selection criteria : Associates worked 8 consecutive days between 9/28/09 and 12/31/09

  Thanks in advance....

  Thanks,

  Kottee

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 28, 2011 at 1:58 am

  #1344993

  Duplicate post.

  Replies here please:

  http://www.sqlservercentral.com/Forums/FindPost1132630.aspx

  -- Gianluca Sartori