Great! This works on the test data, now I go for testing in real!

Thanks so far.

IT WORKS. GREAT! How do you do that without a testbench in from of you....

I have just tried your script and you are right. The first item will give a wrong result (I have again checked what I have expected). The first part has...

Yes, it works on my real data. I had to make some adustments as I had simplyfied my question. So now all works like expected. 😛

THANKS!!

Yes, you are right. Your results are not what I expected to see, but I have to go again and look that what I expected is correct.

Your results are OK!!!!

Now...

No problem for waiting as long as I get a clue how to solve that 🙂

To SSChasing

I have tried your solution with UNION ALL, but the result is not what I am looking for. Problem here is, that also if a part is not sold...

Ok, I hope I have understand and the following is what you need for more help.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mysales','U')...

Ok, it seems that my solution can not work.

Situation as follows (simplified):

Table statsales with fields partnumber, quantity, salesdate

Table parts with fields partnumber, parttype

Table combinations with fields assemblynumber, partnumber, quantity

A...