bgrinde | SQLServerCentral

bgrinde

Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

RE: Finding datetime range intersections and durations

Yes, dates must be included. Sorry for the confusion.

And yes, I need the total common time for each combination (intersection) i.e., ...

P1&P2, P1&P3, P2&P3,...

October 27, 2004 at 9:22 am

#528178
RE: Finding datetime range intersections and durations

Thanks for the reply David.

I think I understand your technique in the insert into @hours portion, but I need precision to at least seconds, better would...

October 26, 2004 at 8:52 pm

#528084

Viewing 2 posts - 1 through 3 (of 3 total)