Hi,

thanks on advice for future problems.

I did solve problem with UNION ALL statement.

Before that I did equalize fields in both views.

So for example: if I have in view1...

Hi,

I did add in attachment overlap of two views:

yelow -exist in both views

Thanks

Hi,

In production we have labeling system with scanners which counts the produced products.

On end of each shift ERP collect data about produced quantity's from labeling system and in same time...

Hi,

thanks on replay(after 3 years)!

It is very fast!

In any case I will check this solution, I did make solution for this(with help from SQLServerCentral) and it is running stable...

Hi,

in attachment is sql code what I did try for one shift(for other shifts i was thinking to make loop where I will change @t1 and@t2 according shift...

can anybody help!!!:crying:

Thanks on prompt replay(I was thinking that nobody will answer).

I want to sum time of each state in minutes and group that times by the shifts), but time_stamps sometimes have...