SELECT OriginUsersID, (Various Aggregations) FROM JTELStats.StatisticsPartB b JOIN JTELStats.StatisticsPartA a ON b.StatisticsPartAID = a.ID WHERE ( b.ClientsID = _ClientsID ) AND ( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ ) AND ( b.OriginUsersID IS NOT NULL ); |