This is an old thread, and I'm actually working in SSIS (now Visual Studio) 2012 - but I would say this last method (rearranging the order in the code -...

I think a previous post alluded to this, but the last bit of SQL is fine where a customer would only be called once on a given date. If a...