#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2002
    Posts
    99
    Rep Power
    0

    Query with overlapping scedule/location/dates


    The image says it all. I have a scedule with locations and timeslots. How can I retrieve the userid's that have had overlap with me.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Mar 2008
    Posts
    1,927
    Rep Power
    378
    An overlap is, for instance, anyone in the same location whose start date is before your end date and whose end date is after your start date.
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,118
    Rep Power
    4274

IMN logo majestic logo threadwatch logo seochat tools logo