Timeline for Can't read data out of XML stored in table column
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 6, 2023 at 12:31 | comment | added | ChrisF |
Cheers. The annoying thing is that I'd started out with declaring Id as INT in the WITH statement but when that produced NULLs I thought it was due to the types being wrong so I went with VARCHAR instead. If I'd found the colPattern definition first I might have got there myself.
|
|
| Jan 6, 2023 at 12:30 | vote | accept | ChrisF | ||
| Jan 6, 2023 at 12:26 | history | answered | Martin Smith | CC BY-SA 4.0 |