By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| TopLevelDescription | ImmediateParent | ItemDescription | Navigation | Qty | BIMUnique |
|---|---|---|---|---|---|
| Top Level Order Description | 0 | Top Level Order Description | 1 | 1 | 660084 |
| Top Level Order Description | Top Level Order Description | Second Level Order Description | 1.1 | 50 | 660085 |
| Top Level Order Description | Top Level Order Description | Second Level Order Description w/sub order | 1.2 | 200 | 660086 |
| Top Level Order Description | Second Level Order Description w/sub order | Third Level Order Description | 1.2.7 | 10 | 660087 |