• No, makes less sense.

    The query i posted doesn't return just rows from before 6:02. It would return all rows between 5:55 and 14:05 inclusive.

    If the intervals are every 5 minutes, why is there a count at 5:54 and another at 6:02? (8 minutes apart)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass