Thanks Sean, I've noted your point about primary key naming.

TaskNameList is a lookup table to associate lists, list names and tasks with each other. This is the part of the...

ScottPletcher (9/28/2012)

---

And for general performance reasons, get rid of the functions on the date/datetime column:

SELECT p.product,

SUM(CASE WHEN j.holiday = 0 THEN j.qty_delivered END)...

Perfect. 😀

Thanks Laurie.