Wouldn't mind seeing a sample of a worst case CTE and a solution with a temp table, for example.

Hi, yes all three work and the final updates into the #storeproducts table. Thank you again. Using CTE in this case shows clearly what the...

The first answer is the solution. (WITH previousweek...) Terrific. The updates do go into the storeproducts table which holds the ...

Yes, I totally understand. I am constantly going back to the table designs for this project and have drawn up my own schema that I constantly refer to....

So Sorry. Will need some time to put it all together. Thanks for letting me know.