New to the board so let me know if I'm posting in the right place. Having an issue with this statement.

Essentially, I have a table that highlights a process and the start and end time of that process. I already run a convert to varchar to manipulate the time and am going to give you in the format that the time is in after the convert. (sorry if formatting is a little off)

Process

Start

End

Work

8:00AM

5:00PM

Dishes

8:00PM

8:20PM

Sleep

11:00PM

6:00AM

Walk the Dog

6:30AM

7:00AM

Now, I'm trying to query to see if I am within a 10 minute window of any of the start or end times (using getdate for the server time). If I can't do that, I'd love to be able to determine any time frame that is not within a 10 minute window of ANY of the start and stop times. If this is not realistic, let me know.

SQLTeam does not have the concept of marking threads as answered/closed. If you leave it alone, after a while activity trails off and it dies a natural death.

Nobody gets any credits either. My guess is that most people who answer questions do it for the joy they get out of solving problems, and for the opportunity it affords them to learn and sharpen their own skills. I know it is so for me.