Topic: SQL copy with case or if?
Hi MVD,
Right now I have table like this:
Orders;
OrderNO. Item Size Quantity
1111111 ITEM22 28 3
2222222 ITEM18 22 4
333333 ITEM22 26 3
1111111 ITEM22 22 1
1111111 ITEM22 26 2
I would like to copy these orders to other table that look like this:
OrderFiltered:
OrderNO: Item 22 26 28
1111111 ITEM22 1 2 3
2222222 ITEM18 4 0 0
3333333 ITEM22 0 3 0
Thank You for all Your help