By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
5 rows affected
Id | MPath | DisplayText | OnHandQty | Level | ParentId | MaxCanMake | AvailToSell |
---|---|---|---|---|---|---|---|
9 | 0 | Laptop & Bag Kit | 3 | 0 | 0 | null | null |
26 | 0.20 | Bag | 23 | 1 | 9 | null | null |
8 | 0.5 | Laptop Kit | 11 | 1 | 9 | null | null |
7 | 0.5.10 | Laptop | 5 | 2 | 8 | null | null |
6 | 0.5.15 | Power Supply | 4 | 2 | 8 | null | null |
5 rows affected
DisplayText | OnHandQty | MaxCanMake | AvailToSell |
---|---|---|---|
Laptop & Bag Kit | 3 | 15 | 18 |
---Bag | 23 | 0 | 23 |
---Laptop Kit | 11 | 4 | 15 |
------Laptop | 5 | 0 | 5 |
------Power Supply | 4 | 0 | 4 |