Home Forums SQL Server 2008 T-SQL (SS2K8) Strategy for n-level approvals RE: Strategy for n-level approvals

  • March 8, 2013 at 12:20 pm

    #1595093

    Lowell, not quite understanding. Here's what I think you said...

    SELECT * from tblEvents

    WHERE (tblEvents.EventDateTime >

    (Select Max(EventDateTime) from tblEvents

    WHERE EventType='Rejection' and TimesheetID=23))

    AND tblEvents.TimesheetID=23

    Jim