Thank you all. The solution provided by Ken is exactly what I need.

Thank you very much Ken. I'm thaking a look at your suggestion

IdLog is the PK for ArticlesInStock

CREATE TABLE [dbo].[ArticlesInStock] (

[IdLog] [int] IDENTITY (1, 1) NOT NULL ,

[DateLog] [datetime] NOT NULL...

thank you goodguy, hope this helps you understand:

--1. whether I understood your problem correctly or not?

yes, i think you get the problem. The process is:

Start

look at the articles in...

Due to production optimization (which cause some over production) there are some

articles that have no destination order. This articles are stored to a temporary store.

Every morning the first...