Page History

SELECT      (Various Aggregations)
FROM        JTELStats.StatisticsPartA a
LEFT JOIN   JTELStats.AcdStatisticsPartB acdb
    ON      a.ID = acdb.StatisticsPartAID
LEFT JOIN   JTELStats.StatisticsPartB b
    ON      acdb.ID = b.AcdStatisticsPartBID
WHERE       ( a.ClientsID = _ClientsID )
            AND
            ( a.dtCallStart BETWEEN _Timeslice_Begin AND TIMESTAMPADD( MINUTE, 15, _Timeslice_Begin ) )
            AND
            ( a.bOutbound = 0 )
GROUP BY     a.ID;