• Hi ChrisM@Work,

    Thank you for your reply. In attachment you will find the executionplan. The Tussen_Tickets table has at this moment 31779 records.

    The query is almost correct. I only had to change Talk = SUM(tt.OnHold) to Talk = SUM(tt.Talk) in the OUTER APPLY.

    I also saw that the Event_Channel is not always filled (NULL) and not always correctly sorted.

    Is that maybe your remark that you saw that my previous post puts column event_channel into the left-hand side along with date, from the Tussen_Ticket table?

    Greetz,

    Geert