Client_Id Load_1 RTC TS1733 1 8/21/2014 16:10 TS1733 1 8/21/2014 17:00 TS1733 1 8/21/2014 17:10 TS1733 1 8/21/2014 17:20 TS1733 1 8/21/2014 17:30 TS1733 0 8/21/2014 17:40 TS1733 0 8/21/2014 17:50 TS1733 1 8/21/2014 18:00 TS1733 1 8/21/2014 18:10 TS1733 1 8/21/2014 18:20 TS1733 1 8/21/2014 18:40
Client_ID Load_1 TimeDuration(Minute) TS1733 1 130 TS1733 0 20
SELECT Client_Id, Load_1, DATEDIFF(minute, MIN(RTC), MAX(RTC)) AS [TimeDuration(Minute)] FROM MyTable GROUP BY Client_id, Load_1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)