Tech Off Post

Single Post Permalink

View Thread: SQL Query...can't seem to wrap my head around this
  • User profile image
    ploe

    Maddus Mattus said:

    So if I understand correctly, you only want rows included that have a ten minute intersect?

     

    And if no rows are found you want a default selection?

     

    Then I would suggest you develop a cursor to fill a temp table and if the table has 0 rows, fire off another query,..

    Then select the temp table as a resultset,..

    Yes, if a row overlaps a specified datetime, not only return that row, but all the rows that are in the 10-minute adjacent set this row belongs to.