Yes, it really was "Quit with Success" <G>

Seems as if I may have eliminated the problem now.

I hear you... but the Joins are on PKs:

Products: ProductID

Stores: StoreSysID

Franchises: MFnum

DayTrans: StoreSysID, SaleDateTime, ProductID, PurchaseUnitID

ProductPriceLink: StoreSysID, ProductID, PurchaseUnitID

I don't think I can optimise those more!

Now I have to confess I don't...

Phil - I think that's it.

In fact last night I had already completely taken that line out, on the basis that it was a local, temporary table - therefore couldn't...

No mate - the other way around!

"TCSDailyNumbersIntoConfig" is the SP from my #1

"sfbUpdateProductSalesSummary" is the SP from my #2

Forget about #2... it...

This supplied code is *not* the one running for a long time - that was my item #2 which in fact *is* working.

That one is very intensive.... about 12000s...

Can find no other history info that tells me any more.

Output (file) just tells me it's failed on Step 1 !!!!

Fine... didn't want to drown you in code, first up! <g>

I should say that it appears that I'm quite wrong about item #2 - it was just my impatience, because...