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