Hi Phil

I am not sure with the 'link in your signature' so I will respond this way:

The 100, 110, etc is the fluctuation of the stock, in other words the stock being sold on different day. The 100, 110, etc. is the stock that is left on that day. Every day the stock at a certain branch will be different. What essentially has to happen is I need to create in my ssis package a for loop that will populate a table from the dates stipulated what the stock at a certain branch are. This was I will see if the stock needs to be ordered, or if one branch has stock that the other don't have, then move the stock to the branch that do not have the stock.

Kind regards

Fred