That worked!

Thank you very much!!

Thank you guys...

I was able to solve the issue using Lowell's approach!

Thanks again.

Thank you very much Atif...

That helped a lot!!!!

Hi Atif,

Thank you for your reply.

None of the columns are static, everything is dynamic, the number of machines will increase and the number of Tools will increase.

Your query works, the...

I believe you got it!!!!

Thank you so much!

Perfect!!

Thank you very much!

Hi,

Thanks for your reply.

If you do it that way the order for part TTY is correct but not for XYZ.

B should be before A.

The lowest number should always be first.

I got it.

For someone looking for the same:

SELECT PART, QTY, BATCH1 = CASE WHEN PART='A' AND QTY < 10 THEN 10 ELSE 0 END, BATCH2 = ..........