Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, July 26, 2017

Consolidate Overlapping Datetimes

SQLServerCentral » Latest topics
Consolidate Overlapping Datetimes

Scenario: An operator can chat with multiple users throughout a day and I need to calculate how long they actually spent within the chat tool.

Problem: Each chat interaction is recorded in a table with a start datetime and end datetime. The op

No comments: