## How to determine if a 2nd service was done within 2 min of the other

Solved
Frequent Contributor
Posts: 80

# How to determine if a 2nd service was done within 2 min of the other

Hi team I'm working on 2 tables an I need to determine if table1  service A was done within 2 min of table2  service B..

And also  to determine how many  service B  did not have any service A here is example

TABLE 1

ID.    Ser    Start.                                        End

Qw.    A     23May2016:00:34:00.     23May2016:00:40:00

TABLE 2

ID.    Ser    Start.                                        End

Qw.   B    23May2016:00:35:00.     23May2016:00:41:00

In the example table One open within 2 min of the 2nd service I would want to see table two in a dataset

That's first part  here is 2nd part

TABLE 1

ID.    Ser    Start.                                        End

Qw.    A     26May2016:00:29:00.     26May2016:00:40:00

TABLE 2

ID.    Ser    Start.                                        End

Qw.    A     26May2016:00:38:00.     26May2016:00:40:00

On this example what it's showing is there was a service B but no service A open up within 2 min I would want that on its own dataset .... thanks again  for help ay

Accepted Solutions
Solution
‎05-30-2016 10:26 PM
Super User
Posts: 5,876

## Re: How to determine if a 2nd service was done within 2 min of the other

Perhaps a SQL right join with a table1.end between table2.end - 2 minutes and table.end + 2 minutes join criteria (pseudo code)?
Data never sleeps

All Replies
Solution
‎05-30-2016 10:26 PM
Super User
Posts: 5,876

## Re: How to determine if a 2nd service was done within 2 min of the other

Perhaps a SQL right join with a table1.end between table2.end - 2 minutes and table.end + 2 minutes join criteria (pseudo code)?
Data never sleeps
🔒 This topic is solved and locked.