I must be missing somthing here, I'm no SQL expert (in fact I'd never come accross CTE's before) but that seems like an awfull lot of code for what, on the face of it, seems like a pretty straight forward report. There's reams of it man!! I'd have been there till midnight producing that lot 🙂 Not only would I have missed dropping the kids off I would have missed picking em up too. Might look a bit closer at the CTE's though...