geert.de.vylder (3/1/2013)
Hi ChrisM@Work,Thank you for your query and help. But this query needed 13 minutes to run. That's quiet long. How can the performance be improved?
Greetz,
Geert
Post the actual execution plan as a .sqlplan file, and I'll tell you. But is it correct? Your last post puts column event_channel into the left-hand side along with date, from the ticket table.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden